excel formula in alteryx (=Cell A1&&","& Cell A2)

Question

Hi all, I am trying to figure out this formula in Alteryx. I have a column of data (column A) but I would like the output to be something like column C where the data would constantly be reading from the previous cell. Would anyone have experience in this issue before or if there are any ideas/suggestions. Thank you!

kamal03 · Accepted Answer

Hi @gavinloi_

There can be multiple ways to do this but the easiest method is to use a multi-row formula tool.

Try the below workflow and let me know if it worked for you or not.

binu_acs · Accepted Answer

@gavinloi_

malteryx1 · Accepted Answer

You can simply use the multirow formula and convert the datatype to string. PFA