Hi, there!
I am writing to my trusted source to rule out that my vision is not executable. Here goes:
I want to update an existing field with its previous/existing values and in conjunction tack on new values. Is there a way for me to do this? Can I concatenate the value from the existing field w/ new values from the same field? As a caveat, I am using SmartConnect to do this (by creating a new task). I came up with two different queries hoping to execute my thoughts:
UPDATE tblNAME
SET fieldNAME=fieldNAME+ ', ' + 'fieldNAME'
WHERE Master_ID = 'PayerID' ---Master_ID is a field from tblNAME, and Payer_ID is a field from the Excel sheet that has the new value to be added to fieldNAME.
INSERT INTO tblNAME (fieldNAME)
SELECT fieldNAME
FROM tblNAME
WHERE Master_ID = 'PayerID'---the same is true as above.
I am writing to my trusted source to rule out that my vision is not executable. Here goes:
I want to update an existing field with its previous/existing values and in conjunction tack on new values. Is there a way for me to do this? Can I concatenate the value from the existing field w/ new values from the same field? As a caveat, I am using SmartConnect to do this (by creating a new task). I came up with two different queries hoping to execute my thoughts:
UPDATE tblNAME
SET fieldNAME=fieldNAME+ ', ' + 'fieldNAME'
WHERE Master_ID = 'PayerID' ---Master_ID is a field from tblNAME, and Payer_ID is a field from the Excel sheet that has the new value to be added to fieldNAME.
INSERT INTO tblNAME (fieldNAME)
SELECT fieldNAME
FROM tblNAME
WHERE Master_ID = 'PayerID'---the same is true as above.