I have two tables Actual & Forecast as below, Actual ForecastItem2024 20252026Item2024202520261122454221245230210215025648882300320340Monitor222254987USB14028042031002003003200400600Keyboard444334164Web Cam130260390Table203040Table406080 I need to join/union both the tables and need a output like below, Is this doable in Alteryx, please help Item202420252026202420252026112245422245230210215025648883003203403100200300200400600Table203040406080Monitor222254987000Keyboard444334164000USB000140280420Web Cam000130260390

of course, like this ? maybe you can transpose it .Item2024_AC2025_AC2026_AC2024_FC2025_FC2026_FC2024_AC-FC_DF2025_AC-FC_DF2026_AC-FC_DF112245422245230210-123224-18821502564888300320340-15022445483100200300200400600-100-200-300Keyboard444334164000444334164Monitor222254987000222254987Table203040406080-20-30-40USB000140280420-140-280-420Web Cam000130260390-130-260-390

Joining Unmatched records in alteryx .

Alteryxexpert

I have two tables Actual & Forecast as below,

Actual	Forecast
Item	2024	2025	2026	Item	2024	2025	2026
1	122	454	22	1	245	230	210
2	150	2564	888	2	300	320	340
Monitor	222	254	987	USB	140	280	420
3	100	200	300	3	200	400	600
Keyboard	444	334	164	Web Cam	130	260	390
Table	20	30	40	Table	40	60	80

I need to join/union both the tables and need a output like below, Is this doable in Alteryx, please help

Item	2024	2025	2026	2024	2025	2026
1	122	454	22	245	230	210
2	150	2564	888	300	320	340
3	100	200	300	200	400	600
Table	20	30	40	40	60	80
Monitor	222	254	987	0	0	0
Keyboard	444	334	164	0	0	0
USB	0	0	0	140	280	420
Web Cam	0	0	0	130	260	390

Developer

Gallery

Developer Tools

Macros

Download

Expression

Events

Accepted answers

All comments

Qiu

@Alteryxexpert
For start, Alteryx does not allow same column name😁

ShankerV

Hi @Alteryxexpert

One way of doing this..

Screenshot 2024-04-23 131017.png

Many thanks

Shanker V

ShankerV

Hi @Alteryxexpert

Step 1:

Step 2:

Step 3:

Step 4:

Many thanks

Shanker V

ShankerV

Hi @Alteryxexpert

Step 5:

Step 6:

Step 7:

Step 8:

Step 9:

Step 10:

Many thanks

Shanker V

flying008

Hi, @Alteryxexpert

FYI.

录制_2024_04_23_15_51_06_331.gif

Actual					Forecast
Item	2024	2025	2026		Item	2024	2025	2026
1	122	454	22		1	245	230	210
2	150	2564	888		2	300	320	340
Monitor	222	254	987		USB	140	280	420
3	100	200	300		3	200	400	600
Keyboard	444	334	164		Web Cam	130	260	390
Table	20	30	40		Table	40	60	80


Output
Item	2024_AC	2025_AC	2026_AC	2024_FC	2025_FC	2026_FC
1	122	454	22	245	230	210
2	150	2564	888	300	320	340
3	100	200	300	200	400	600
Keyboard	444	334	164	0	0	0
Monitor	222	254	987	0	0	0
Table	20	30	40	40	60	80
USB	0	0	0	140	280	420
Web Cam	0	0	0	130	260	390

Alteryxexpert

Can you attach the workflow please

flying008

Hi, @Alteryxexpert

IIF(IsEmpty([_CurrentField_]), 0, [_CurrentField_])

录制_2024_04_23_16_20_30_798.gif

Alteryxexpert

Thanks you, Is there a way to compute difference between AC and FC Columns, A Variance Computation, 2024 AC-2024FC & so on?

flying008

of course, like this ? maybe you can transpose it .

Item	2024_AC	2025_AC	2026_AC	2024_FC	2025_FC	2026_FC	2024_AC-FC_DF	2025_AC-FC_DF	2026_AC-FC_DF
1	122	454	22	245	230	210	-123	224	-188
2	150	2564	888	300	320	340	-150	2244	548
3	100	200	300	200	400	600	-100	-200	-300
Keyboard	444	334	164	0	0	0	444	334	164
Monitor	222	254	987	0	0	0	222	254	987
Table	20	30	40	40	60	80	-20	-30	-40
USB	0	0	0	140	280	420	-140	-280	-420
Web Cam	0	0	0	130	260	390	-130	-260	-390

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703