Discussion Board for collaboration on QlikView Scripting.
I'm facing issue to create rowno based on ID. Please check the below image for your reference what i'm expecting output
rowno should starts with 1 for every new ID. Please help me out...
Go to Solution.
You can do like below in Preceding Load
AutoNumber(RowNo(), ID) as RowNo
Please share some sample data....
Or Please try like this
LOAD * , RowNo();
LOAD * Inline [
You can use AutoNumber(RecNo(), ID) AS RowNo