topic Re: Load CSV files into database unstructure in Talend Studio

Load CSV files into database unstructure

Anonymous — Sat, 16 Nov 2024 08:14:33 GMT

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.

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 07:57:08 GMT

@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('.'))

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 10:34:31 GMT

@lalitkothawade,still do you have issue?

Re: Load CSV files into database unstructure

Anonymous — Tue, 22 May 2018 11:17:19 GMT

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 (.).

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 11:28:00 GMT

@lalitkothawade,you can exteact using tExtractDelimitedFields.

check the below link to know the detals of tExtractDelimitedFields

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

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 11:43:22 GMT

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

Re: Load CSV files into database unstructure

amitdadri — Tue, 22 May 2018 12:04:20 GMT

Re: Load CSV files into database unstructure

Anonymous — Tue, 22 May 2018 12:22:58 GMT

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

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 12:24:11 GMT

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

Re: Load CSV files into database unstructure

Anonymous — Tue, 22 May 2018 12:26:12 GMT

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

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 12:28:24 GMT

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

Re: Load CSV files into database unstructure

Anonymous — Tue, 22 May 2018 12:43:36 GMT

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

Re: Load CSV files into database unstructure

Anonymous — Tue, 22 May 2018 12:50:07 GMT

Thank you... Its working

Re: Load CSV files into database unstructure

manodwhb — Tue, 22 May 2018 12:59:02 GMT

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