Apply a delimiter

[EmilAlteryx01]

How can I apply a delimiter to this feed - not gettin the output if its a blank column

DATE|Location|Store Location|Retail Manager|Employee Name|Employee ID|Brand|Days in Ware House|Days in Storage|Store Comments|Warehouse Comments|Value

07/31/2024 00:00:00|India|Bangalore|Joe Dsilva|HemantH|231201|Nike|32|2|||25500

07/31/2024 00:00:00|India|Bangalore|Joe Dsilva|RioS|231211|Nike|12|1||Dispatched|2500

Outcome

DATE	Location Store	Location	Retail Manager	Employee Name	Employee ID	Brand	Days in Ware House	Days in Storage	Store Comments	Warehouse Comments	Value
07/31/2024 00:00:00	India	Bangalore	Joe Dsilva	HemantH	231201	Nike	32	2			25500
07/31/2024 00:00:00	India	Bangalore	RioS	HemantH	231211	Nike	12	1		Dispatched	2500

[Qiu · Accepted solution]

@EmilAlteryx01 
It works on my end.

[aatalai · Accepted solution]

@EmilAlteryx01 does this do the trick

[EmilAlteryx01]

Hi Qiu

Hi aatalai

I have accepted both as a solution - Both the workflows are Identical and has helped resolve my issue