Putting Yearly Data side by side

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

Workflow

Help

Accepted answers

davidskaife

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

Join Multiple.yxmd

Felipe_Ribeir0

Hi @Deano478

Here is how i would approach this problem:

crosstab.yxmd

All comments

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

crosstab.yxmd

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

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

Join Multiple.yxmd

Felipe_Ribeir0

Hi @Deano478

Here is how i would approach this problem:

crosstab.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335