topic Re: comparing two fields from two different tables in QlikView

comparing two fields from two different tables

Tue, 27 Oct 2015 19:44:25 GMT

Hi .. still a newbie ...

Loading in two tables from two different spreadsheets.

I want to compare a column from table week3 with a column in table week4 and return a column 'compare'

week3:
LOAD hostname,
status as wk3status,
os as wk3os,
osversion as wk3osversion,
serialno as wk3serialno,
discoveredserialno as wk3discserialno,
parenthostname as wk3hostname
FROM

(ooxml, embedded labels, table is [10-18-2015]);

week4:
LOAD hostname,
status as wk4status,
os as wk4os,
osversion as wk4osversion,
serialno as wk4serialno,
discoveredserialno as wk4discserialno,
parenthostname as wk4hostname
FROM

(ooxml, embedded labels, table is [10-25-2015]);

if(wk3serialno <> wk4serialno, 'good','bad');

Obviously, that if statement isn't working. How can I add an additional column to my overall data where if wk3serial <> wk4serialno, then 'nomatch'.

Re: comparing two fields from two different tables

sunny_talwar — Tue, 27 Oct 2015 20:27:34 GMT

May be something like this:

week3:
LOAD hostname,
status as wk3status,
os as wk3os,
osversion as wk3osversion,
serialno as wk3serialno,
discoveredserialno as wk3discserialno,
parenthostname as wk3hostname
FROM

(ooxml, embedded labels, table is [10-18-2015]);

week4:
LOAD hostname,
status as wk4status,
os as wk4os,
osversion as wk4osversion,
serialno as wk4serialno,
discoveredserialno as wk4discserialno,
parenthostname as wk4hostname
FROM

(ooxml, embedded labels, table is [10-25-2015]);

Temp:

LOAD hostname,

wk3serialno

Resident week3;

Join(Temp)

LOAD hostname,

wk4serialno

Resident week3;

Table:

LOAD hostname,

if(wk3serialno <> wk4serialno, 'good','bad') as Flag

Resident Temp;

DROP Table Temp;