Formula Help

Question

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

jaygerbs · Accepted Answer

@AngelosPachis Thanks for the response.  I wish I could say I was advanced enough to know exactly what you did.  Could you please give me a screen shot of the multi-row formula configuration & formula.

I am not a analytics guy in any degree......

AngelosPachis · Accepted Answer

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.