Help Adding Underscore At End of Number

[arnolyuna]

Hi, I have a set of account numbers that I need to add an underscore to the end of, so 1234 to show as 1234_ I recall doing this a while ago but cannot remember how, I know it ended & "_" as .... but cannot remember? I've look online, but cannot find the solution? Any suggestions please?

[QFabian]

Hi @arnolyuna , you are in the right path, just use single quotes, here an example :

Data:

Load

AccountNumber,

AccountNumber & '_'  as AccountNumberWithUnderscore, //maybe is better to keep the original field and create a new one

others fields....

FROM YourSource;