Data Formatting

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

Analysis.xlsx

Transformation

Accepted answers

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

Example_Solution_jrlindem_v2.yxzp

All comments

binu_acs

@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 @binu_acs - 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 / @binu_acs - Never mind. This is pretty straightforward. Thank you for your help.

jrlindem

@binu_acs

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

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

Example_Solution_jrlindem_v2.yxzp

knnwndlm

Thank you @jrlindem ! I did something similar but I like yours better.

jrlindem

@knnwndlm My pleasure. Glad it was helpful and ultimately, that you got it figure out so you could progress in your work! Cheers -Jay

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703