List of File names and Content in it

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

Datasets

Data Investigation

Accepted answers

Qiu

@mohit9garg

This should help you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-packaged-workflow-File-types-yxzp/td-p/640288

cgoodman

What I mean is this:

1) in the file input add an asterix in the file path so that it acts as wildcard to read in all .txt files in that directory.

2) select output file name as a field

On the website there is this new post on resources for batch macros.

All comments

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.

0126-mohit9garg.yxzp

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703