Four Stars

Load CSV files into database unstructure

I have csv file in that 3 columns are present but in one column the data will be unstructured like

175.4A.EC-413.ZN-F.175.4h.TC-420.ZN-F.Present Value, I want to seperate that (.) into columns, how to load this type of csv file into mysql database through talend??? please help us. I have attached csv file for reference.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,if you are facing issue,please check the belwo one.

Untitled.pngUntitled.pngUntitled.png

 

Manohar B
Five Stars

Re: Load CSV files into database unstructure

stringToColumn1.pngstringToColumn2.png

13 REPLIES
Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,you need out as "175.4A.EC-413.ZN-F.175.4h.TC-420.ZN-F" ?

 

if yes you can use below expression in tmap.

 

row1.col.substring(0,row1.col.lastIndexOf('.'))

Manohar B
Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,still do you have issue?

Manohar B
Four Stars

Re: Load CSV files into database unstructure

my input is like 175.4A.EC-413.ZN-F.175.4h.TC-420.ZN-F  and i want ouput as separate columns like 

175  4A  EC-413 means separated by (.).

Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,you can exteact using tExtractDelimitedFields.

 

check the below link to know the detals of tExtractDelimitedFields

https://help.talend.com/reader/9q55KsfASqX0qY4GVhEDNQ/0is4W2Xc7rQp8mFGjxIDRw

Manohar B
Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,if you are facing issue,please check the belwo one.

Untitled.pngUntitled.pngUntitled.png

 

Manohar B
Five Stars

Re: Load CSV files into database unstructure

stringToColumn1.pngstringToColumn2.png

Four Stars

Re: Load CSV files into database unstructure

why we used tfixedflowinput.. what is content in it..???

Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,to generate the source data by using the tFixedInputFlow.

Manohar B
Four Stars

Re: Load CSV files into database unstructure

What is columnfromstring...?? is that component or only name and if only name then which component is that??

Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,it is tFileInputDelimmited,just given name for the Componnet Label format in View of tFileInputDelimmited.

Manohar B
Four Stars

Re: Load CSV files into database unstructure

we have already csv data ready, no need to generate the data..

Four Stars

Re: Load CSV files into database unstructure

Thank you... Its working

Twelve Stars

Re: Load CSV files into database unstructure

@lalitkothawade,please accept the solution and also give Kudos.

Manohar B