UnPivot doesn't take two delimiter together

prashant
Topic Author
Offline
Platinum Member

More

2 years 3 months ago #23491 by prashant

UnPivot doesn't take two delimiter together was created by prashant

I have dataset flowing in where I have comma and a space in the form.

IN Unpivot window it does allow me to take an input of comma & space together but the resulting output still has the extra space

Example

Hello, My friend, we meet

Output is

Hello
My friend (with space)
we meet (with space)

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

admin
Offline
Administrator
Deeds not Words

More

2 years 3 months ago #23496 by admin

Replied by admin on topic UnPivot doesn't take two delimiter together

We will have a look at it,

please use trim function for now

www.etl-tools.com/wiki/advanced-etl-proc...ctions/strings/trim/

Mike
ETL Architect

The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

Peter.Jonson
Offline
Administrator

More

2 years 3 months ago #23497 by Peter.Jonson

Replied by Peter.Jonson on topic UnPivot doesn't take two delimiter together

The issue you reported was addressed in the latest release.

27/03/2024 6.4.2.18

+ Improved: String delimiter handling

Peter Jonson
ETL Developer

The following user(s) said Thank You: prashant

Please Log in or Create an account to join the conversation.

prashant
Topic Author
Offline
Platinum Member

More

2 years 3 months ago #23503 by prashant

Replied by prashant on topic UnPivot doesn't take two delimiter together

WOHOOO !!!

Please Log in or Create an account to join the conversation.

ETL Forum