topic Re: QVD Load in QlikView

QVD Load

Anonymous — Mon, 13 Jul 2015 19:45:21 GMT

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

(qvd)

ORDER BY SessionId, [TimeStamp] ASC;

Please help me with idea.

Thanks,

swuehl — Mon, 13 Jul 2015 20:00:36 GMT

Here are some ideas to circumvent the limitations of autonumber in incremental load (if that's what you are interested in):

Anonymous — Mon, 13 Jul 2015 20:18:12 GMT

Thanks for reply.

I used order by and it works.

The problem was in concant sql file and qvd file.