Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Transpose a table into a single line text file

Hi,

 

I need to export a table into a single line text file to then post to an API on a different platform.  

 

If I have a table eg

ID, Value

1,345546

2,433245

3,434645

4,546456

5,234235

I then need to transpose it into a single line and export it, as a text file, in the following format 

 

{"1": "345546","2": "433245","3": "434645","4": "546456","5": "234235"}

Is this possible?

 

Many thanks,

 

Phil

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Create a text box and insert the below expression

='{' & Concat('"' & ID & '"'& ';' & '"' & Value & '"' ,',') & '}'

after that export it to Excel (Since there is no way you can export it to text file in qlikview unless you use macros)

View solution in original post

1 Reply
Highlighted
Creator II
Creator II

Create a text box and insert the below expression

='{' & Concat('"' & ID & '"'& ';' & '"' & Value & '"' ,',') & '}'

after that export it to Excel (Since there is no way you can export it to text file in qlikview unless you use macros)

View solution in original post