Transpose rows to columns

[twanqlik]

I'm trying to transpose the following table:

Input:

%Classification_Key	AttributeID	Value%Table
de_DE_7	PH-CATALOG-EOP	2037-10-10
de_DE_7	PH-CATALOG-PRD-AUDIENCE	B2B
de_DE_7	PH-CATALOG-PRD-CTN	REGTE
de_DE_7	PH-CATALOG-PRD-TARGET	PRD-308941
de_DE_7	PH-CATALOG-SOP	2016-10-04
de_DE_7	PH-IsActive	true
de_DE_7	PH-IsDeleted	false
de_DE_7	PH-IsEnabled	true

Output:

PH-CATALOG-EOP	PH-CATALOG-PRD-AUDIENCE	PH-CATALOG-PRD-CTN	PH-CATALOG-PRD-TARGET	PH-CATALOG-SOP	PH-IsActive	PH-IsDeleted	PH-IsEnabled	%Classification_Key
2037-10-10	B2B	REGTE	PRD-308941	2016-10-04	true	false	true	de_DE_7

I'm really struggling with this. How to do this in the scripting part, not on the front-end

[sunny_talwar]

Check here

Data Table Transformation in Qliksense

[sewialwork]

You can check your options hereGroup by explanation‌ or here Multiple rows with different dimensions

AGB

[sunny_talwar · Accepted solution]

Another example

how to combine after generic load

[vamsee]

Hello,

I think you are looking for Generic Load

The GENERIC Load – QLIKIES

Generic LOAD

%Classification_Key,

AttributeID,

Value%Table

From Source;

[twanqlik]

It creates 1 table per field.

It can work on the front-end, but this is not what i'm searching for

[twanqlik]

Thanks, this worked:

Table:

LOAD * INLINE [

    ID, NAME, VALUE

    1, name1, val1

    1, name2, val2

    2, name1, val3

    2, name2, val4

    3, name1, val5

    3, name2, val6

    4, name1, val7

    4, name2, val8

    5, name3, val9

];

FinalTable:

LOAD Distinct ID

Resident Table;

FOR i = 1 to FieldValueCount('NAME')

LET vField = FieldValue('NAME', $(i));

Left Join (FinalTable)

LOAD ID,

VALUE as [$(vField)]

Resident Table

Where NAME = '$(vField)';

NEXT i

DROP Table Table;