Create Fields from data

[ecabanas]

Hi,

I want to create a new table when I'm loading the script. I have this table as example:

createdat	SalesId	Brand	Revenues
01/01/2019	PV001	X	10 €
01/01/2019	PV001	Y	10 €
01/01/2019	PV001	Z	10 €
01/01/2019	PV002	X	10 €
01/01/2019	PV002	Y	10 €
01/01/2019	PV002	Z	10 €
31/01/2019	PV003	X	10 €
31/01/2019	PV003	Y	10 €
31/01/2019	PV004	Y	10 €
31/01/2019	PV004	Z	10 €

But I want to create a table like this to do some calculations:

SalesID	BrandX	BrandY	BrandZ
PV001	1	1	1
PV002	1	1	1
PV003	1	1
PV004			1

How do automatically that X, Y, Z (or N brands) as fields?

Thank's

[dwforest]

Crosstable

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[patilamay]

I think you are looking for generic load. 

See the below blog post

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470