Help to create logic

[Kushal_Chawda]

Dear All,

Need help. Please find the attched file for the logic

[Gysbert_Wassenaar]

See attached example.

[jagan]

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;