Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sort data in different field at load

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

1 Solution

Accepted Solutions
MayilVahanan

HI

PFA

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI

PFA

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Thank you, it is exactely what I needed.

Beste regards,

N