Hello team,
I'm still a newbie in Alteryx ^^'
Recently, I've been using the "Join multiple" which helped me to resolve my problem in a very quick and smart manner. But I've got issues with arranging the data.
Here's an example:
In the "data" sheet, I have a list of people with their ID, name and Age.
Another department is in charge of attributing gifts to each people every month. And since a different person is in charge of filing each month data, rows might contains different information in addition to the the basic ones.
I used the "join multiple" tool which permitted me to obtain results. However, I have to put all the common data in one row instead of #1, #2, #3, etc. Like in the "Result" sheet.
For this example, I only took 3 months and one row to assemble (3 months x 1 row to assemble = 3 Rows) but in reality it's larger like 12 months and 3 to 4 rows to assemble (12 x 4 = Up to 48 rows)
I tried to use Formula tool with an aim to concatenate the data but it took a lot of time,
I join the excel sample here,
