Putting Yearly Data side by side

[Deano478]

Hi Community,

I have a quick question that might be simple but I'm just not sure how to go about doing it basically I have three inputs containing 2020, 2021 and 2022 data and essentially I want to align the 2021 data alongside the 2020 data and same for the 2022 data alongside the 2021 data. 

Is this action possible in Altyerx if so any guidance would be majorly appreciate my head is fried trying to figure it out 😂

Many thanks to you all in advance.

The 2021 and 2022 data follows the same structure 

Code	Name	Sum_Total	Year
ABCD01_T	Company 1	600	2020
EFGH02_G	Company 2	18681	2020
HUJK07_B	Company 3	4000	2020
ADVK09_A	Company 4	950	2020
QQRU90_B	Company 5	10534	2020
GGGG09_T	Company 6	19801	2020
AAAA06_B	Company 7	700	2020
BFHS98_T	Company 8	6216	2020
DVSB19_V	Company 9	7425	2020

[Felipe_Ribeir0]

Hi @Deano478 

Without seeing the data its a little hard to guess, but i think that the cross tab tool would do the job for you.

Example input (after unioning 2021 and 2022 inputs)

Output

[JamesCharnley]

Hi @Deano478 

Easiest way to do this is probably use a formula to create a field for 'Year-1' and then join Year to your new Year-1

[ChrisTX]

Can you post sample input and desired output?

You could try the Join Multiple tool, but it is limited to joining on only one field.  So you may need to first create a single concatenated field, if you need to join on multiple field values.

Chris

[Deano478]

Hey @Felipe_Ribeir0  my bad about that I'll grab a dummy sample and post it 

[davidskaife · Accepted solution]

Hi @Deano478 

Do you mean like this?

I've attached a workflow with two different ways of doing it - using multiple Join tools, and also with a Join Multiple tool :)

[Felipe_Ribeir0 · Accepted solution]

Hi @Deano478 

Here is how i would approach this problem:

[Deano478]

Hey @Felipe_Ribeir0 and @davidskaife  Huge thanks to both of you guys I got it too work after taking your solutions and adding a bit to them cheers to you both