topic Re: How to write a code in exists function between two tables in Visualization and Usability

How to write a code in exists function between two tables

Wed, 25 Mar 2015 05:24:06 GMT

i have writing to a code in exists () between two tables...but i have face some errors.i have attached the qvw file please check it.

i am looking for the answer

if where not exists(F1)

i want to display

F1 F2

1 200

2 300

3 400

4 500

5 600

Re: How to write a code in exists function between two tables

sushil353 — Wed, 25 Mar 2015 05:29:57 GMT

Hi,

Try this code

Tab1:
LOAD F1,
F2
FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
;

Tab2:
LOAD F1,
F2
FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where not Exists(F1);

HTH

Sushil

Re: How to write a code in exists function between two tables

Anonymous — Wed, 25 Mar 2015 05:58:23 GMT

use attached qvw

Re: How to write a code in exists function between two tables

Wed, 25 Mar 2015 10:42:39 GMT

Tab1:

LOAD F1,

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Tab2:

LOAD F1,

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Tab3:

load * resident Tab1;

load * resident Tab2 where not exists(F1,F1);

It state first parameter F1 represent Tab1 field will look into second parameter F1 represent Tab2 field if it will not exist in Tab2 then those field-value will be taken into F1 rest exclude.

& in your script both table field are same it will auto-concatenate to avoid that rename Tab3 field values...