topic Re: Convert flat file or properties to csv like row in Talend Studio

Convert flat file or properties to csv like row

_AnonymousUser — Sat, 16 Nov 2024 13:07:24 GMT

Hi,
I have many files like properties with key=value.
i want to merge it in flow where key = column, ill try with tmap but i dont know how to do it.
I Search idea

Re: Convert flat file or properties to csv like row

Anonymous — Thu, 27 Jan 2011 03:59:06 GMT

Hello
Please give us an example of your file and what are your expected result?
Best regards
Shong

Re: Convert flat file or properties to csv like row

Anonymous — Thu, 27 Jan 2011 14:36:39 GMT

Hi,
Arnaud_ is my.
Then Example :
I have 10 property file in this format :
key1=value1
key2=value2
key3=value3
And i want
key1;key2;key3
value1;value2;value3
value1;value2;value3
value1;value2;value3
...
I have always same keys in each file.
I dont need to pass by file, i just need flow with key,value converted in column value.
for this i try
tFileList ------> tIterateToFlow -----> tFileInputDelimited (key,value) sep (=) -----> tmap

Sorry for my powless english, im french and thx for your help

Re: Convert flat file or properties to csv like row

Anonymous — Thu, 27 Jan 2011 15:22:42 GMT

Hello
Here I do a demo job for you about your request. In this example, there are only two properties file under my folder:
file1.txt:
key1=value1
key2=value2
key3=value3
file2.txt:

key1=value4
key2=value5
key3=value6
For more information, please see my screenshots.
Best regard
Shong

Re: Convert flat file or properties to csv like row

Anonymous — Wed, 02 Feb 2011 10:11:15 GMT

Ok thanks ill try it