Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have 3 fields as input (first sheet in attached excel), and i need to populate data in new field called "OrderID_Partition" using these three fields.
I have tried using below
Data:
Load
*
from Sample Data;
Load
*,
if(rowno()=1 or TalkID<>previous(TalkID) OR StoreID<>previous(StoreID),1,peek('OrderID_Partition')+1) as OrderID_Partition
Resident Data TalkID, BreakID, StoreID;
But proper result i am not getting... expected result is in sheet 2 in attached excel. Can anyone help me please.
Thanks,
Raju
Sounds good
Please remember to mark any helpful response as they might end up being helpful for others in the future
Best,
Sunny
Sure