How to handle a file with double pipe || delimiter in data loading file activity ACC

Avatar

Avatar
Level 1
ratika
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
ratika
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
View profile
ratika
Level 1

10-04-2021

Hi Everyone,

 

I have a requirement for data import flows where in the import files are delimited with double pipe ||.

Sample as below

 

ratika_0-1618066173994.png

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.

ratika_1-1618066265002.png

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 3
Level 3
Amit_Shinde
Level 3

Likes

22 likes

Total Posts

17 posts

Correct reply

11 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 3
Level 3
Amit_Shinde
Level 3

Likes

22 likes

Total Posts

17 posts

Correct reply

11 solutions
Top badges earned
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
Amit_Shinde
Level 3

12-04-2021

Hi Ratika,

 

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.

 

Amit694_0-1618226812645.png

 

Thanks,

Amit

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

168 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

168 likes

Total Posts

928 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

22-04-2021

Hi @ratika,

Were you able to resolve this query with any of the given solutions or do you still need more help here? Do let us know.

Thanks!

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

10-04-2021

Hi @ratika

for delimiters one character is used in most cases.
Maybe someone will have better idea but I would suggest that you use only one pipe "|" as a delimiter. This will produce a lot of additional empty columns. Later in Enrichment node just pick the ones you need.

Regards,

Milan