Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (2)
4 Replies
Anonymous
Not applicable

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

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
Anonymous
Not applicable

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
Anonymous
Not applicable

Ok thanks ill try it