Data Formatting

[knnwndlm]

Hi SME,

I have two sets of data that when joined using the Class_A_ID/Class_B_ID, the Amt (B) tied to Class_B_ID would be repeated to match up with the Amt (A) from Class_A_ID, as shown in the Data tab in the attached file.  What I want to get is the Result tab, where if Amt (B) is repeated within Class_A_ID or Class_B_ID (doesn't matter.  Columns I/J on the Result tab is my approach to get this work by using the Tile tool.  However, when I used the Tile tool, I only got column J to materialize - couldn't get both so that I can use the Multi-Row Formula tool to get what I need.

Any suggestions on how I can do this?

Thanks,

kwl

[binuacs]

@knnwndlm What is the expected result you are looking for?

[dreldrel]

Not sure why you'd need to use a Tile tool, but you can consider using the formula tool with contain syntax to check if Amt (B) is within either Class_A_ID or Class_B_ID.

[knnwndlm]

Hi @binuacs - I want to get the Result tab columns A-H.  Columns I/J were just my attempt to get the Tile to work so I can use the Multi-Row Formula tool to achieve the Result tab.

[knnwndlm]

Hi @dreldrel - I need the Tile tool to make sure that Class_A_ID and Class_B_ID are together as a block before I remove any dups in column G - as shown on the Result tab.

[knnwndlm]

@dreldrel / @binuacs - Never mind.  This is pretty straightforward.  Thank you for your help.

[jrlindem]

@binuacs 

Here's the authors previous thread on this need:  Stacking Two Set of Data Side-by-Side - Alteryx Community

I believe they are still trying to solve for the non-repeating values that I commented on towards the end of the thread.

[jrlindem]

@knnwndlm 

I was able to add in a RowNumber for both the "A" side and "B" side.  This allows the join to only look for the first instance of record on either side, eliminating the repeating row you and I were working on late last week (Stacking Two Set of Data Side-by-Side - Alteryx Community).

Here's the revised workflow (also posted on the other thread) and attached.  I agree with @dreldrel that using the Tile tool should not be necessary.  See if this gets you further along:

Reach out if not, -Jay