Convert flat file or properties to csv like row

One Star

Convert flat file or properties to csv like row

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
Community Manager

Re: Convert flat file or properties to csv like row

Hello
Please give us an example of your file and what are your expected result?
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Convert flat file or properties to csv like row

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
Community Manager

Re: Convert flat file or properties to csv like row

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Convert flat file or properties to csv like row

Ok thanks ill try it