topic Re: QlikSense Excel file Transformation in App Development

QlikSense Excel file Transformation

psenthilbtech — Sat, 16 Nov 2024 19:16:18 GMT

Hi Team,

I have a excel file in the below format .

S.No FundName 2018 Assets 2019 Assets 2018 Subscribers 2019 Subscribers

i have to convert the source into below format

S.No FundName Year Assets Subscriobers

Need your help on this

Regards,
Senthil

marcus_sommer — Tue, 21 Jan 2020 16:13:40 GMT

You could use two Crosstable-Loads - one for Assets and one for Subscribers - and then joining them together.

- Marcus

Gui_Approbato — Tue, 21 Jan 2020 16:14:48 GMT

1) Load the columns in separate loads

2) Create the Year column with the year value

3) rename the columns so that they can automatically concatenate.

See example below:

Load

S.No ,

FundName,

'2018' as Year,

2018 Assets as Assets,

2018 Subscribers as Subscribers

From [lib://Source];

Load

S.No ,

FundName,

'2019' as Year,

2019 Assets as Assets,

2019 Subscribers as Subscribers

From [lib://Source];