Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Need help. Please find the attched file for the logic
See attached example.
Hi,
Try this script
Data:
LOAD
AcctNo,
Date,
Type,
Amt,
Transaction
FROM
Test.xlsx
(ooxml, embedded labels, table is Sheet1);
Inner join (Data)
LOAD
*
WHERE UniqueTransaction = 1;
LOAD
AcctNo,
Date,
Transaction,
Count(Distinct Amt) AS UniqueAmt,
Count(Transaction) AS UniqueTransaction,
Count(Distinct Type) AS UniqueType
Resident Data
Group By AcctNo,
Date,
Amt,
Transaction;
Hope it helps you.
Regards,
Jagan.
DROP FIELDS UniqueAmt, UniqueTransaction, UniqueType;