topic Re: Incemental load issue in QlikView

Incemental load issue

Thu, 23 Jun 2016 10:45:58 GMT

Hi all,

I have a couple of fact tables where i don't have any datefield to incremental load, but i have primary key like somesequential id.

my doubt how can i do incremental load without datefield in that table.

sequentail id format:1614/00003478,

1514/00005678

like that

Please help me how to incremental load using sequence id alone..

Thanks in advance

Kushal_Chawda — Thu, 23 Jun 2016 10:53:35 GMT

Table:

SQL SELECT *

FROM Table;

concatenate(Table)

LOAD *

FROM Tablename.qvd(qvd)

where not exists([sequentail id ]);

Store Table into ..\Tablename.qvd;

effinty2112 — Thu, 23 Jun 2016 11:01:26 GMT

Hi Vijay,

Does 1614/00003478 come before 1514/00005678? Do the different prefixes mean that you have two (or more) different number sequences?

Cheers

Andrew

Thu, 23 Jun 2016 11:04:27 GMT

no it will not come like that ,1615 will come after that only

gautik92 — Thu, 23 Jun 2016 11:31:31 GMT

replace that / and try lik this

Replace(sequentialid,'/','')