Dynamic Input file and vlookup

[gavinloi]

Hi all,

Currently on a daily basis, i would have an excel with different dates  on it and currently i am trying to solve this error as even if i use (*) to make the file path dynamic it generates an error. My workflow would be that it takes 2 different excel files (1 static) and (1 dynamic) before creating a new column and doing a vlookup. Would there be any way to solve this dynamic path ?

Thanks!

[Qiu]

@gavinloi 
To help us better understand the issue can you kindly confirm

1. Are the dynamic and Static Excel files located in the same folder?

2. Are the dynamic excel file having any naming convention?

3. Can you give a set of sample data files?

[gavinloi]

Hi Qiu,

Many thanks for the prompt response.

1. Are the dynamic and Static Excel files located in the same folder? - the files would be in separate folders 

2. Are the dynamic excel file having any naming convention?- nope so it would be quite standard just that the date would change accordingly. example dynamic file_20210520 for today, dynamic file_20210521 for tomorrow and so on.

3. Can you give a set of sample data files? - Have attached the excel files.

Would there be an issue if the folders are in different locations?

Thank you!

[Qiu · Accepted solution]

@gavinloi 

Thank you for the sampel file.

The question 1 and 2 are related.

If they are in the same folder, we need a naming convention to differentize them when using wild card for the dynamic one.

Herei is the sample flow and hope I am undersstand you correctly.

[gavinloi]

Hi Qiu, 

I realised that the file would be in .csv format, would that make a difference in the file path ?

[Qiu]

@gavinloi 
I dont think so.

[gavinloi]

Weird, it's giving me the above error though. Do you have any idea whats causing it ?

[Qiu]

@gavinloi 
maybe your file path with quote mark?

Can you show me your whole error message?

[atcodedog05 · Accepted solution]

Hi @gavinloi 

Small enhancement on @Qiu's workflow which might be helpful to you. Set "Start Data import on line" configuration of input tool to 2. So that 2nd line with column names is correctly referred and becomes your Alteryx field names

Next step would be to use find & replace tool to do vlookup

Resource on find & replace tool : https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201 

Hope this helps 🙂

[atcodedog05]

@gavinloi 

and can you share the sample csv file which you are using. It says issue in record 1 the issue can also be in data too.