topic How to create a flag with same value in the loading script in QlikView

How to create a flag with same value in the loading script

jim_chan — Tue, 22 Dec 2020 11:08:44 GMT

Hi there,

i have a problem here. i need to write this in loading script, as a flag/dimension.

My expected result, when i add a TYPE dimension, it will help me to differentiate which ID number is 'positive with same ID' and 'Not the same'.

This is the ID number Group data which indicate which ID number is in the same ID group.

I have attached a sample qvw file, please help me out!

Rgds

Jim

Re: How to create a flag with same value in the loading script

jim_chan — Wed, 23 Dec 2020 01:16:10 GMT

hello anyone?

Re: How to create a flag with same value in the loading script

edwin — Wed, 23 Dec 2020 01:50:16 GMT

the requirement is unclear. with these two tables, how do you identify which ones are positive line with same ID?
what are the rules?

Re: How to create a flag with same value in the loading script

jim_chan — Wed, 23 Dec 2020 02:38:14 GMT

example ID number 12345 & 135789, this 2 numbers are in the same ID_GROUP 10001.

Re: How to create a flag with same value in the loading script

MayilVahanan — Wed, 23 Dec 2020 05:02:18 GMT

Hi @jim_chan

Try like below

Temp:
LOAD * INLINE [
ID_GROUP, ID_NUMBER
10001, 12345
99999, 678910
10001, 135789
];

Join
LOAD * INLINE [
ID_NUMBER,COUNTRY,COLOR
12345, US,BLUE
678910, JAPAN,RED
135789, ITALY,ORANGE
];

Join
Load *, if(Count = 1, 'Not Same', 'positive with same ID') as TYPE;
Load ID_GROUP, Concat(ID_NUMBER, ',') as Group, Count(Distinct ID_NUMBER) as Count Resident Temp
group by ID_GROUP;