CSV File - Multiple structures within the same file

[Punit_Kapadia]

Have a CSV file

Date	Count of Orders	Category	Amount	Currency
01-Jan-24	2	Shoes	100	USD
Date	Order Number	Amount
01-Jan-24	1001	50

The above data structure is an output of Altreyx Workflow and when exported to csv with delimiters is as below: 

Header Row: Date;Count of Orders; Category; Amount; Currency

Row 3: Date;Order Number; Amount;"";"";

How to exlude the last 2 delimiters while exporting the data

Expected CSV Output

Header Row: Date;Count of Orders; Category; Amount; Currency

Row 3: Date;Order Number; Amount

Find and Replace does not seem to work. 

[Raj]

@Punit_Kapadia 
As while writing the data to CSV
it is taking the valued from headers and as the value are not present for specific row this is not going to eliminate the value 
else while rerunning the CSV the columns would be missing, and this can cause error when data is huge.

hope this help.

[Punit_Kapadia]

@Raj Is there a way to get the output in the expected format. As it's required for a system upload and does fail because of the schema

[Raj · Accepted solution]

@Punit_Kapadia 
please find the workflow attached
this should work.

[Raj]

@Punit_Kapadia 
does that work?

[Punit_Kapadia]

Thanks Raj. It does work.