QlikSense Excel file Transformation

[psenthilbtech]

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]

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

- Marcus

[Gui_Approbato]

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];