Specific data to be copied to consolidated file

Question

Hi All- New to Alteryx community and learning alteryx , i was building a case and wanted to solve. I have scenario where i have three input files and i extract specific data from each file every month on month and i need to paste it to consolidated file. I need to maintain consolidated file since it will have history and will be used for further analysis.

Input 1 - Copy  - column name (Data  7 ) not the entire column example December in this case.

Input 2 - Copy - column name (Data 7) not the entire column  example December in this case.

Input 3 - Copy - column name (Data 4) not the entire column need December in this case.

Please help me in building a robust solution

Input 3.xlsx

Consolidated Sheet.xlsx

Input 2.xlsx

Input 1.xlsx

SeanAdams · Answer

If the format / shape of the data is identical in each file, then just use an input tool with *.xlsx as the filename - and then do a filter for the month and write it out to a file.

The output tools even allow you to specify the filename dynamically so you could overwrite every month's files when you get a data refresh and split the consolidated file out into months (with different filenames per month)

randreag · Answer

I'm not sure if I understand your question

Here some explanation , first the input is loading the 3 files at the same time, after that I transpose all the columns and join them just with the ones you need (you can put more)

Then concatenate the name of the file with the field and again crosstab.

So in that order, all the data from all the files is there.

Please, Let me know if it is clear

prveenk86kumar · Answer

Thanks for the response, i was trying this out but its copying entire row from the first input file itself rather then taking specific column and if i 3 input files adding that to transpose will be difficulty right.