Load only on certain condition

Anonymous — Fri, 13 Jun 2014 02:07:27 GMT

In the attached Excel sample, I have 2 rows for each transaction based on EMPID. I only want to load the 2 rows if the "Matched" column has equal values for the 2 rows. So in my example, I don't want the first 2 or last 2 rows to load because the values are "I" and "O" for EMPID 1, and "A" and "B" for EMPID 4. Is there a way to do this on a load statement, and if not, how can it be done in the dashboard? I don't want to see those rows at all in the dashboard if the "Matched" values are not equal. I've tried different things with a Where clause, but I can't figure out how to compare the rows to find out if they match or not.

Re: Load only on certain condition

Anonymous — Fri, 13 Jun 2014 02:23:28 GMT

Below script may help you

tbl1:

LOAD

EmpID

Where RecCnt=1;

LOAD EmpID,

Count(DISTINCT [I/O]) as RecCnt

FROM

Matched.xlsx

(ooxml, embedded labels, table is Sheet1)

Group by EmpID;

tbl2:

LOAD EmpID,

EmpName,

CustName,

Item,

Desc,

Qty,

Price,

[I/O]

FROM

Matched.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Exists(EmpID);

DROP Table tbl1;

topic Load only on certain condition in QlikView

Load only on certain condition

Re: Load only on certain condition