How to avoid duplication of Header in Output files

[Nethaji_5]

Hello All,

I'm trying to consolidate all the files in a folder to a single spreadsheet. But I'm facing duplication of header name from all the files and also, I could see F1, F2 as column names.

I need proper heading without duplication of headers, please let me know your suggestions.

[atcodedog05 · Accepted solution]

Hi @Nethaji_5 

Can you provide the workflow with the input files.

2 things you need to do.

1st use dynamic rename and select config below

now you have the needed header

2nd now use filter to remove the rows where [Date]='Date' (Date column contains value date)

This should fix it.

The reason its happening is your data in file is not starting from row 1 but row 2

Hope this helps 🙂

[Nethaji_5]

Hi atcodedog05

Thanks for your reply, I'm sorry I could not able share my input files it's confidential.

FYI: 

The attached image looks same as my input data. I hope this will be helpful for you.

[atcodedog05]

Hi @Nethaji_5 

Can you share the excel which is in the screenshot. 

[Nethaji_5]

Thanks, I need to learn a lot😊

[atcodedog05]

Hi @Nethaji_5 

Were you able to solve it with the above steps ?

[Nethaji_5]

Working

[atcodedog05]

Happy to help 🙂 @Nethaji_5 

Cheers and Happy Analyzing 😀