Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I used SQL script with condition from temporary table
TempTable:
Load
Chr(39) & Concat(Distinct SessionId,Chr(39) & ',' & Chr(39)) &Chr(39) as ConcatValue
Resident
COMMENT_URLs;
Let vValue2=FieldValue('ConcatValue',1);
Drop Table TempTable;
SESSIONS:
LOAD AutoNumber(Id) as Auto_Id,*;
SQL SELECT Id, [SessionId]
,[TimeStamp]
,[Ip]
,[Url]
FROM [SEAC].[dbo].[UserTrack] where SessionId in ($(vValue2))
ORDER BY SessionId, [TimeStamp] ASC;
Now I have qvd file SESSIONS FINAL with all records. I want to add autonumber for my qvd file for each SessionId
QVD:
LOAD AutoNumber(Id) as Auto_Id,*
FROM
ORDER BY SessionId, [TimeStamp] ASC;
Please help me with idea.
Thanks,
Here are some ideas to circumvent the limitations of autonumber in incremental load (if that's what you are interested in):
Autonumber Handling for QVD Optimized Load (via Key Storage)
Thanks for reply.
I used order by and it works.
The problem was in concant sql file and qvd file.