Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a table im loading from A QVD
that i want to enumerate the rows
basicly add the Row No based on if %User_Key has another row for the same date via %Calendar_Key
i have tried the load below but it does not give me the resulkts intended
Load
AutoNumber(RecNo(),[%User_Key]) as rowNo,
[%User_Key] as User,
[%Calendar_Key] as Udate,
Activity_Entry_Type ,
_Contacts
Resident F_TimeInField_tmp2;
Row No | %User_Key | %Calendar_Key | _Contacts | Activity_Entry_Type |
1 | DaveA | 22-Jan-2020 | 25 | Full Blank Week-Day with Contacts |
2 | DaveA | 22-Jan-2020 | 25 | ToT Entry |
1 | RobB | 22-Jan-2020 | 20 | ToT Entry |
1 | JanC | 23-Jan-2020 | 19 | Full Blank Week-Day with Contacts |
1 | ErikA | 23-Jan-2020 | 18 | Full Blank Week-Day with Contacts |
2 | ErikA | 23-Jan-2020 | 18 | ToT Entry |
Any Help Appreeciated