topic Re: Split a table in QlikView

Split a table

AmCh — Tue, 04 May 2021 13:03:36 GMT

Hello all,

I have the following table (xls.) as an input:

System	Variant
A	11
A	12
A	13
B	21
B	22
B	23
C	31
C	32
C	33

I want to import those fields separetly and named:

Fields:

A_Variants

B_Variants

C_Variants

Any help please?

Thanks in advance.

Re: Split a table

Taoufiq_Zarra — Tue, 04 May 2021 14:10:47 GMT

@AmCh

Maye be like this:

Data: LOAD * INLINE [ System, Variant A, 11 A, 12 A, 13 B, 21 B, 22 B, 23 C, 31 C, 32 C, 33 ]; Tmp: load distinct System as SysTmp resident Data; FOR Each a in FieldValueList('SysTmp') LOAD Variant as '$(a)_Variant' resident Data where System='$(a)'; NEXT a drop table Data,Tmp;

output: