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

Announcements
Join us in Toronto Sept 9th 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