Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hey Community! I a newbie to Alteryx, although pretty strong in Microsoft Excel, I am struggling with formulas in Alteryx. So I am looking to you all for some help!!!
I am trying find matching strings in Column A, then concatenating the info in Column B into Column C. The attached picture should help. It really doesn't matter if there are empty cells in Column C or not as long as all the data is there & the order doesn't matter.
Thanks in advance! JG
Solved! Go to Solution.
Hi @jaygerbs ,
Do you also need the digits in front of each element of column B? If yes then it's the second rout, where you have to use a multi-row formula tool to assign an ID to each element of Column B that belongs to elements of column A.
The formula tool won't give you what you are looking for, try using a summarize tool instead.
Cheers,
Angelos
Hi @jaygerbs ,
I have attached a workflow of the solution I created in my previous post, which would work better than a screenshot I think.
No need to by an analytics guy, I will explain the solution immediately:
Select Tool
Needed to change the size of the fields to accommodate the concatenated values later on.
Multi-Row Formula
Create an ID for each one of the rows of the Field 1 values. The multi-row formula tool, operates on a single field, from the first record to the last one in your dataset. Top to bottom
Formula tool
Having created that field for an Identifier, we can then include it to the original "Field 2", with this expression
ToString([ID per Group])+"."+[Field2]
Summarize tool
For each distinct value in Field1, concatenate whatever is included in Field 2.
Does this help? Please feel free to ask any questions. If you click once on each tool, you can get a brief description of what the tool does + you can click on Open examples and you will be taken to some workflows coming with Alteryx, explaining how each tool work.
