Split a table

[AmCh]

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

11

12

13

B_Variants

21

22

23

C_Variants

31

32

33

Any help please?

Thanks in advance.

[Taoufiq_Zarra · Accepted solution]

@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: