Is there any components or Idea?

Matillion ETL
1

Hi all,

I have 4 data in a single row with comma(,) as delimiter ex:(9159664455,582244555,4785154546,5565566546),here I want to bring the 4 data in 4 different columns.

So,is there any idea or logic to solve this?.

2

use the SPLIT_PART function in Matillion:

 

SPLIT_PART("C1", ',', 1)

SPLIT_PART("C1", ',', 2)

 

Where C1 is the input string

', ' is the delimiter

1 is the n-th occurence

 

When there are always 4 values this, added with 2 additional lines for 3 and 4 will do and will give you columns. See the added json for import in Matillion

3

@HariRamK​ In matillion we have a component named as Split Field which helps you to achieve your output.

069Tm000004BbrfIAC_0D7Tm000000qwhRKAQ
069Tm000004BbrfIAC_0D7Tm000000qwhRKAQ699×413 19.4 KB

4

Yeah, I think this one will help me more. Thanks for your time and help.

5

Ok I got it I will try it