topic Transpose rows to columns in QlikView

Transpose rows to columns

twanqlik — Thu, 30 Aug 2018 14:08:56 GMT

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

Re: Transpose rows to columns

sunny_talwar — Thu, 30 Aug 2018 14:17:16 GMT

Check here

Data Table Transformation in Qliksense

Re: Transpose rows to columns

sewialwork — Thu, 30 Aug 2018 14:17:28 GMT

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

AGB

Re: Transpose rows to columns

sunny_talwar — Thu, 30 Aug 2018 14:19:10 GMT

Another example

how to combine after generic load

Re: Transpose rows to columns

vamsee — Thu, 30 Aug 2018 14:24:30 GMT

Hello,

I think you are looking for Generic Load

The GENERIC Load – QLIKIES

Generic LOAD

%Classification_Key,

AttributeID,

Value%Table

From Source;

Re: Transpose rows to columns

twanqlik — Thu, 30 Aug 2018 14:37:31 GMT

It creates 1 table per field.

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

Re: Transpose rows to columns

twanqlik — Thu, 30 Aug 2018 15:04:03 GMT

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;