split fields in two or more with LOAD INSTRUCTION

[pgarcia75]

HELLO

I have an input database with two columns: KeyId and Reference

The Reference column contains alphabetical values, separated by commas (Field1, Field2, Field3, etc.).
The number of fields separated by a comma varies from record to record

I want to load this table, with in addition I will create a new table in QLICKVIEW, formed by key ID and field

Example
Input table TABLE0:
2345 XXX, YYY
7654, ZZZ, XXX, AAA

I wish to load and have in QLICKVIEW:

TABLE1 (KeyId, Application):
2345 XXX, YYY
7654, ZZZ, XXX, AAA

TABLE2 (KeyId, Reference):
2345, XXX
2345, YYY
7654, ZZZ
7654, XXX
7654, AAA

Thanks for your feedbac

Patrice

[sunny_talwar]

Try like this

LOAD KeyId,

     SubField(Application, ', ') as Reference

FROM ....;

[Anil_Babu_Samineni]

Are you expecting some thing in Model from one table to 2 tables

[pgarcia75 · Accepted solution]

Thanks, I will try

P

[pgarcia75]

Thanks, It's OK

P