list - multiple values

[rafael5958]

I have a table like this:

column A	column B
A	1
B	2
C	5
D	2
E	5

And I what to create a "filter list"

that contains

A

B

C

D

E

A B C

A D E

DC

Is that possible?

[MarcoWedel · Accepted solution]

something like this?

tabList:
LOAD * Inline [
    columnA, column B
    A, 1
    B, 2
    C, 5
    D, 2
    E, 5
];

tabFilterList:
LOAD FilterList,
     SubField(FilterList,' ') as columnA
Inline [
    FilterList
    A
    B
    C
    D
    E
    A B C
    A D E
    D C
];