Sort data in different field at load

[#1]

Hi,

Please help me out wit a code to be inserted into the script:

I have the following table to load

Code    Name

123      Text1

124      Text2

128      Text3

234      Text4

238      Text5

239      Text6

543      Text7

656      Text8

I need to load all the Names that has a code that starts with 1 into a filed named Code1_Names, the Names that has a code that start with 2 into filed Code2_Names. All the other names must not be loaded at all.

My table in Qlikview should look like this:

Table 1:

Code1   Code1_Names

123       Text1

124       Text2

128       Text4

Table 2:

Code2  Code2_Name

234      Text3

238      Text4

239      Text5

Thanks,

Nandor

[MayilVahanan · Accepted solution]

HI

PFA

Hope it helps

[#3]

Thank you, it is exactely what I needed.

Beste regards,

N