How to avoid duplication of Header in Output files

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.

Workflow

Developer

Developer Tools

Connectors

Dynamic Processing

Download

Accepted answers

atcodedog05

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 🙂

All comments

atcodedog05

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.

Nethaji_5

Thanks, I need to learn a lot😊

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703