Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Combine/permute two table fields (A,B) (1,2) (A1,A2,B1,B2)

Hi,

Does anybody know what should be the best way to permute/combine in script two table fields into one?

Example:

Table1:
LOAD * INLINE [
    F1
    A
    B
    C
    E
    E
];


Table2:
LOAD * INLINE [
    F2
    1
    2
    3
];


Result expected:
Combination_field
A1
A2
A3
B1
B2
B3
C1
C2
C3
D1
D2
D3
E1
E2
E3

THANKS!

Tags (2)
1 Reply
Not applicable

Re: Combine/permute two table fields (A,B) (1,2) (A1,A2,B1,B2)

Hi,

You can see the attached example.

Best regards.

Community Browser