Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;