Sign in to Community
Sign in to view all badges
I have a requirement for data import flows where in the import files are delimited with double pipe ||.
Sample as below
Can anyone please help me handle this? I tried changing the delimiter as || in the data loading activity but that doesn't seem to work.
You need to enable the option Consider the consecutive delimiter as one & need to give the single pipe as the column separator.
Below is the screenshot for reference. Hope this helps.