Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pamaxeed
Partner - Creator III
Partner - Creator III

Load .xls transformation

Hi,

i have a kind of doubt if it is possible in qlik to perform a Transformation, like i will Show now, of an .xls table we have got from our customer.

The source .xls table looks like that:

Is.PNG.png

and i would like to get a flat table and transform the .xls Input as following:

To_be.PNG.png

Is that possible to redefine the structure in this way?

Thanks and best regards,

Patric

1 Reply
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Have a look at the attached example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!