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

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

want to run & formula.yxmd