Data Formatting in Files.

[Srawat]

Hi,

Can anyone help me to formatting the data in different files. I have a folder and there are lots of files and in the each file have a particular tab with name "SAP Data" and want to see the data in proper format. please refer to the below screen. I need a macro where after running the macro all files "SAP data" tab format in one go.

Data 

Folder have lots of  files. like this.

Please refer to the attached a sample file and please advise.

Thanks

[FrederikE]

Hey @Srawat

So you just want to unionize the data from all files into a single file? 

You can just use a Wildcard-Input ("*" in the Input Path), this way every single file is written underneath eath other. When you want to keep the info which table it comes from, use "Output File Name as Field" aswell. 

This works, as long as the columns do have the same name. Since this is SAP Data it should be the case. 

[Srawat]

@FrederikE  hi, I just want that file should be remain same because there are other tab as well. So, just need a macro where they go to the each file and format the particular tab "SAP Data" and left same as it is.

[FrederikE]

Hey @Srawat,

That's fine, you already have that configured the specific sheet in the Input file. 

You just need to make sure that all the data is in one folder, then it works. 

You can see in the attached pic that both files (duplicated yours one time) are being read. The we end up with 2*26 records beeing written underneath each other. The sheet "a" is never read by Alteryx. 

[Srawat]

@FrederikE  Can you please share a sample workflow so that I can see and test. Thanks.

[FrederikE]

@Srawat,

Here is a packaged sample WF. I didn't send this at first because all it is is the Configuration window of a Input Tool and you need to manually change the filepath.