Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I want to calculate cases by Branchcode/Ip_address,month wise in script level, Please find the sample data...Please help me out this issue.I'm manually calculate flag in attached data
Input:
LOAD IP_Address,
BranchCode,
IP_Address & BranchCode as Key,
[Case ID+],
[Down Since],
Month([Down Since]) as Month,
[Up Since],
Flag
FROM
[222759.xlsx]
(ooxml, embedded labels, table is Sheet2);
Left Join (Input)
Load Key, Count(Month) as Flag2 Resident Input
Group By Key;
Drop Field Key;
Hi
try this pivot table ?
aggr(count(BranchCode),BranchCode)
Try this:
Aggr(Count(BranchCode), BranchCode, IP_Address)
Outcome:
Input:
LOAD IP_Address,
BranchCode,
IP_Address & BranchCode as Key,
[Case ID+],
[Down Since],
Month([Down Since]) as Month,
[Up Since],
Flag
FROM
[222759.xlsx]
(ooxml, embedded labels, table is Sheet2);
Left Join (Input)
Load Key, Count(Month) as Flag2 Resident Input
Group By Key;
Drop Field Key;