Vlookup date columns in multiple inputs based on a dynamic formula input

[Sohdaw]

Hi,

I have a workflow with multiple inputs:

1. Input A

Currency	Account	Name	Date T-1 (19-Dec-2022)	Date T (20-Dec-2022)	Date T+1 (21-Dec-2022)	Date T+2	Date T+3	Date T+4

2. Input B

Currency	Account	Name	Date T-1 (19/12/2022)	Date T (20/12/2022)	Date T+1 (21/12/2022)	Date T+2	Date T+3	Date T+4

Note that the dates in the above are dynamic - the input file gets saved each business day.

I have a separate formula where i have used a text input and formula tool to dynamically create the dates in the below Input C

Date	T-1	T	T+1	T+2	T+3
Dates	19-Dec-2022	20-Dec-2022	21-Dec-2022	22-Dec-2022	23-Dec-2022

Can you advise what tools i can use, based on the dates in Input C, to only select the respective Date columns in Inputs A and B? 

Thanks 

[ShankerV]

Hi @Sohdaw 

Can you please share the sample Input1 and Input2 along with Output.

I agree that the input will be dynamic, Need to understand the logic more as more than words, sample input and output will help to understand better.

Many thanks

Shanker V

[Sohdaw]

Hi  @ShankerV 

Input A - note dates are consecutive including sat / sun.  

Currency	Account	Name	Date T-1 (19-Dec-2022)	Date T (20-Dec-2022)	Date T+1 (21-Dec-2022)	Date T+2	Date T+3	Date T+4
THB	xyz	sdf	123.34	123.34	123.34	123.34	123.34	123.34
THB	adsf	fgs	234.24	234.24	3409.24	3409.24	3409.24	3409.24

Input B - note dates are consecutive including sat / sun.  

Currency	Account	Name	Date T-1 (19/12/2022)	Date T (20/12/2022)	Date T+1 (21/12/2022)	Date T+2	Date T+3	Date T+4
THB	dfe	poo	890.23	890.23	890.23	890.23	890.23	890.23
THB	qwe	llk	900.23	23456.34	23456.34	23456.34	23456.34	23456.34

Input C - formula tool only picks up business days 

Date	T-1	T	T+1	T+2	T+3
Dates	19-Dec-2022	20-Dec-2022	21-Dec-2022	22-Dec-2022	23-Dec-2022

I have an additional mapping table where

Account	Mapping
xyz	TEE
adsf	GER
dfe	TEE
qwe	GER

Output - Dates are based on Input C 

Mapping	19-Dec-2022	20-Dec-2022	21-Dec-2022	22-Dec-2022	23-Dec-2022
TEE	sum of inputs A and B based on account and mapping (so eg. 123.34 + 890.23)
GER

[ShankerV]

Hi @Sohdaw 

There are some excellent posts about vlookup in knowledge.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-for-Excel-Users-How-to-do-a...

Many thanks

Shanker V

[Christina_H]

Do the aliases match in all inputs?  (T, T+1, etc.)  I've used those to join the inputs together.

This works with this set of dates since they sort alphabetically.  For other sets you might need to find a way to sort the columns correctly.