List of File names and Content in it

[mohit9garg]

Hi,

I have thousands of large excel files in a folder and each file contains data for a particular person. Eg, File 1 is for person A, file 2 is for person B..etc

Now I need a mapping of file name and person's name whose data is these in the file. Can someone help me with a workflow.

Thanks

Mohit

[Qiu]

@mohit9garg 

The person's name is stored as Sheet Name or Data inside the sheet?

[mohit9garg]

@Qiu its inside the data. There is column called "NAME" in the data.

[Qiu]

@mohit9garg 

Made a batch macro for this.

[mohit9garg]

@Qiu  Thanks .

But this is not supporting my Alteryx version. I am using version 2020.1.2.24185. Can you please send this workflow again which is compatible to this version.

Regards,

Mohit

[Qiu · Accepted solution]

@mohit9garg 

This should help you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-packaged-workflow-Fil...

[mohit9garg]

@Qiu  Thanks much. But I bit confused on how to fit this batch macro in my workflow. My workflow starts like this. Could you please guide me.

[Qiu]

@mohit9garg 
Add the filter tool after before entering the macro should do the work.

[mohit9garg]

@Qiu  like this?

Kindly excuse my ignorance; I don't have much hands on on Batch Macro (infact I have phobia). So is it possible to do it without Batch Macro.?

[Qiu]

@mohit9garg 

Haha, really?

Acutally, since you mentioned that you have thousands of files, to reduce the computer load, I chose to use macro.

You can go ahead and load them all by once.

Each file schema is same?