Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
psenthilbtech
Contributor III
Contributor III

QlikSense Excel file Transformation

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 

Labels (1)
2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

Gui_Approbato
Creator II
Creator II

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