want to run & formula

[Maheshp]

Hi Team,

I have a data in Alteryx, but I want to add one column and run "&" formula.

I mean I have invoice number # 4230875 but in different column I want the data like "CIS 4230875" in each row, mean I want to add CIS in start from all the invoice number with the help of formula.

Can you please guide.

Regards,

Mahesh

[ShankerV · Accepted solution]

Hi @Maheshp 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @Maheshp 

If you need to overwrite in the same column.

Many thanks

Shanker V