Welcome, Guest
Username: Password: Remember me
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: How to Convert Data in a Single String to Different Columns Separated by a Colum

How to Convert Data in a Single String to Different Columns Separated by a Colum 11 months 3 weeks ago #18572

I got all of the file's data in one string. So, I want to separate it into different columns.

For example input(is single column vertically)

Id=12345
Date=23/08/2018
BrName=B1234
bankccount=1234
Contact=3456
position=
Id=12346
Date=23/08/2017
BrName=B1233
bankccount=1233
Contact=3457
position=

expected output:

Id EntryDate BatchName bank account Contact Position
12345 23/08/2018 B1234 1234 3456
12346 23/08/2017 B1233 1233 3457

Please Assist,
EM

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

How to Convert Data in a Single String to Different Columns Separated by a Colum 11 months 3 weeks ago #18590

Hi Emiliano.

I have created a working example for you.
It uses Keep value transformation function
www.etl-tools.com/wiki/aetle/transformat...ellaneous/keep_value
and "If equal to"
www.etl-tools.com/wiki/aetle/transformat.../strings/if_equal_to




Attachments:

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

How to Convert Data in a Single String to Different Columns Separated by a Colum 11 months 3 weeks ago #18591

Please find a working example for your convenience.

File Attachment:

File Name: Example.zip
File Size:2 KB
Attachments:

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

  • Page:
  • 1

We have 420 guests and no members online