Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Insert a row content in a CSV or EXCEL which is extracted using a DATA extraction activity in a workflow

satishnagarajan
Level 1
Level 1

Hi,

 

I'm trying to insert a new row with content as header and description inside a CSV or Excel sheet using the data extraction.

 

I'm able to insert data as columns, Is it possible to insert a row using a script? 

 

data-extraction.png

 

Thank you!!

1 Accepted Solution
Jonathon_wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Yes, this is trivial with scripting, e.g. execCommand("sed -i '1s/^/<added text>/'").

The data extraction activity supports column headers though, so this should be unnecessary.

 

Thanks,

-Jon

View solution in original post

1 Reply
Jonathon_wodnicki
Correct answer by
Community Advisor
Community Advisor

Hi,

 

Yes, this is trivial with scripting, e.g. execCommand("sed -i '1s/^/<added text>/'").

The data extraction activity supports column headers though, so this should be unnecessary.

 

Thanks,

-Jon

View solution in original post