Pivot data in Export

[agaetisproject]

Hi all,

More and more I am using Qliksense to collect data, process them and create outputs tables that my client then inject in their systems.

Here is a use case to feed a FICO table I am struggling with.

My goal is to export a 'pivot' table looking like this:

Field1	Field2	Field3	Field4	Value1	Value 2	Value3	Value4
A	2	US	IC	10	10	10	10
A	2	GB	IC	8	8	8
A	2	SP	IC	10	10

Instead of this:

Field1	Field2	Field3	Field4	Value
A	2	US	IC	10
A	2	US	IC	10
A	2	US	IC	10
A	2	US	IC	10
A	2	GB	IC	8
A	2	GB	IC	8
A	2	GB	IC	8
A	2	SP	IC	10
A	2	SP	IC	10

Can anyone help me pivoting those and generating a text file straight from the script?

Overall, I would love to know if QlikSense offers apis to produce custom reports from its data as the use case to create fancy export to feed interfacing systems is something I see more an more.

Thanks for your help!