Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Key on CrossTable

Hi,

I have a question, i have load data with CrossTable like this one :

Transform:

CrossTable(LEVEL , VALUE)

LOAD NAME,

     A,

     B,

     C,

     LEVEL&VALUE as key

FROM

......

I want to make LEVEL and VALUE field as a KEY for example LEVEL "A" and VALUE "1", so the KEY will be "A1". how can i make a key from crosstable field.

I really need your help.

Thanks, i really appreciate your help

Regards,

Indra

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

Not sure if this is what you are looking for...but a possible approach:

Data:

LOAD * INLINE [

    NAME, A, B, C

    John, 50, 10, 23

    Richard, 10, 10, 25

    Sean, 20, 200, 22

];

Transform_tmp:

CrossTable(LEVEL , VALUE)

LOAD

     NAME,

     A,

     B,

     C

//     LEVEL&VALUE as key

Resident Data;

Transform:

LOAD

NAME,

LEVEL,

VALUE,

LEVEL &'_'& VALUE as key

Resident Transform_tmp;

DROP Table Transform_tmp;

View solution in original post

3 Replies
danieloberbilli
Specialist II
Specialist II

Not sure if this is what you are looking for...but a possible approach:

Data:

LOAD * INLINE [

    NAME, A, B, C

    John, 50, 10, 23

    Richard, 10, 10, 25

    Sean, 20, 200, 22

];

Transform_tmp:

CrossTable(LEVEL , VALUE)

LOAD

     NAME,

     A,

     B,

     C

//     LEVEL&VALUE as key

Resident Data;

Transform:

LOAD

NAME,

LEVEL,

VALUE,

LEVEL &'_'& VALUE as key

Resident Transform_tmp;

DROP Table Transform_tmp;

Not applicable
Author

Hi Daniel,

Wow, really thanks for your help. It solved my problem.

Super thanks Daniel.

Regards.

Indra

Not applicable
Author

it's good idea Daniel.

Ramya.