topic Re: create flag in QlikView

create flag

Wed, 25 Nov 2020 16:16:04 GMT

Hello Viewers,

There are 2 tables

In 1st table contains 10 records(emp id)

Now I have loaded 2nd table contains 25 records(emp id)

Now I want to create a flag in 2nd table with

Exists(If already exists in 1st table) and

new(If it is new record)

How to accomplish this ????

Please help!!!

Re: create flag

sunny_talwar — Fri, 10 Feb 2017 07:12:39 GMT

May be like this:

LOAD [emp id],

[emp id] as temp_emp_id

....

FROM Table1;

LOAD [emp id],

If(Exists(temp_emp_id, [emp id]), 'Existing', 'New') as Flag,

....

FROM Table2;

Re: create flag

avinashelite — Fri, 10 Feb 2017 07:13:01 GMT

Try like this

Table1:

LOAD

EMP_ID,

...

Table2:

LOAD

EMP_ID,

If(Exists(EMP_ID)='-1','Yes','No') as Flag,

...

Re: create flag

sdmech81 — Fri, 10 Feb 2017 07:24:58 GMT

LOAD *,

emp_id as Check_Emp_Id

FROM Table1;

LOAD *,
emp_id ,

If(Exists(emp_id ,Check_Emp_Id), 'Exists', 'New') as Flag,

FROM Table2;

Check fr emp_id frm table 2's existnace in Table one's Check_Emp_Id

Try

Re: create flag

sunny_talwar — Fri, 10 Feb 2017 07:26:33 GMT

Sachin I think the order within Exists is nor right.... I think it should be

If(Exists(Check_Emp_Id, emp_id), 'Exists', 'New') as Flag,

Re: create flag

Chanty4u — Fri, 10 Feb 2017 07:31:21 GMT

try this

LOAD * INLINE [

emp, name

1, fsfg

2, dds

3, aaas

4, aa

5, gdg

];

LOAD * INLINE [

emp, name

1, fsfg

2, dds

3, aaas

4, aa

5, gdg

6,gg

7,hh

8,rr

];

Left Join (a)

LOAD emp,

Sign(Count(emp)-1) as MultNameFlag

Resident a

Group By emp;

Re: create flag

Fri, 10 Feb 2017 07:31:57 GMT

Thank you guys for your quick response.

Both are helpful.

But I really don't understand

Exists(emp_id)='-1'

Can you please elaborate this(what describes '-1')??

Re: create flag

sdmech81 — Fri, 10 Feb 2017 07:40:43 GMT

HI Sunny I think its correct only:

If(Exists(emp_id ,Check_Emp_Id), 'Exists', 'New') as Flag,

By saying this I m checking emp_id frm table to present in Check_Emp_Id of table 1.

@ Babi.... plss verify once..

Sachin

Re: create flag

avinashelite — Fri, 10 Feb 2017 07:45:12 GMT

Exists() function return an integer value so if its true then it returns -1 else 0

Re: create flag

avinashelite — Fri, 10 Feb 2017 07:47:58 GMT

Sachin, Order should be First loaded column name first and then the second loaded column so it should be

Exists(First table loaded column name ,Second table loaded column name)

Re: create flag

sunny_talwar — Fri, 10 Feb 2017 07:51:20 GMT

I am pretty sure it is the other way around.

Re: create flag

sdmech81 — Fri, 10 Feb 2017 10:02:39 GMT

Yes definitely..Else hw can we load field which is still nt loaded.

Thanks bro:)