inner Join(data) load key, count_EquipmentID Where count_EquipmentID>1; load key, Count(EquipmentID) as count_EquipmentID Group by key; load EquipmentID, '-'&CounterNo as key, CounterNo, 12 as j Resident data;
output: Date EquipmentID CounterNo 9092022,D123,100 9092022,D124,100 9092022,D132,105 9092022,D134,105
Hi @ajaykakkar93 Thankyou so Much for the Reply. Actually the script you used is little confusing for me, as some of my concepts are not clear, sorry for that. If possible can you please explain the working of this script. it would be a great help.