Adding one column country for each file uploaded using macro

Hi Community,

I had done importing the multiple file (contain multiple subfolder - xlsx format) using macro . However, i would like to ask if we able to use Alteryx to perform the following :

1. For all the file imported using marco,may i know how can i adding one column for country into the each file that had been uploaded. The screenshot below is the result that i wanted. I know how to add one column country if only one excel file imported However, i not sure how to build a dynamic workflow to accommodate all the excel file so that i can just add one shot for all the excel file with different country ? I Can anyone share the workflow if experience that before.

Common Use Cases

Accepted answers

All comments

AkimasaKajitani

Hi @SH_94

How decide the Country? Is it from File name or sheet name or any other information?

jamielaird

Hi @SH_94 ,

If the country is in the filename you can get this by choosing one of the options in "Output Filename as Field". This will add a column containing the Filename or Filepath, which you can then parse to get the country name.