Data Formatting in Files.

Question

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

Akash.xlsx

FrederikE · Answer

@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.

New Workflow1.yxzp

Srawat · Answer

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

FrederikE · Answer

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.