Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys (and ladies)
I spen a few hours and can't find the reason, why my rows becomes doubled (actully x4) after adding RecNo function.
Primary I have the table:
Then, I add the Help table and add funciotn RecNo
As the result, I have to much dublicated rows:
I hope, You can help me find the reason..
Or you can help me to REMOVE these dublicates
I believe the RecNo() is creating the sequence of number before DISTINCT kicks in.... May be do DISTINCT and then in the next load do RecNo()
Temp:
LOAD DISTINCT
Team_Code_2,
Achive_Total_Team_2
Resident HELP_TABLE
Order By Achive_Total_Team_2 desc, Team_Code_2;
FinalTable:
LOAD RecNo() as NPK_Team_2,
*
Resident Temp;
DROP Table Temp;
I believe the RecNo() is creating the sequence of number before DISTINCT kicks in.... May be do DISTINCT and then in the next load do RecNo()
Temp:
LOAD DISTINCT
Team_Code_2,
Achive_Total_Team_2
Resident HELP_TABLE
Order By Achive_Total_Team_2 desc, Team_Code_2;
FinalTable:
LOAD RecNo() as NPK_Team_2,
*
Resident Temp;
DROP Table Temp;
Thank you..