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

[Qiu]

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

[ShankerV]

Hi @Alteryxexpert 

One way of doing this..

 

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.

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_])

[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