topic Re: split fields in two or more with LOAD INSTRUCTION in QlikView

split fields in two or more with LOAD INSTRUCTION

pgarcia75 — Wed, 14 Jun 2017 13:45:40 GMT

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

Re: split fields in two or more with LOAD INSTRUCTION

sunny_talwar — Wed, 14 Jun 2017 13:53:46 GMT

Try like this

LOAD KeyId,

SubField(Application, ', ') as Reference

FROM ....;

Re: split fields in two or more with LOAD INSTRUCTION

Anil_Babu_Samineni — Wed, 14 Jun 2017 14:04:01 GMT

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

Re: split fields in two or more with LOAD INSTRUCTION

pgarcia75 — Wed, 14 Jun 2017 14:05:47 GMT

Thanks, I will try

Re: split fields in two or more with LOAD INSTRUCTION

pgarcia75 — Wed, 14 Jun 2017 14:13:51 GMT

Thanks, It's OK