topic Re: Where Exist function when loading two different Sources full loads before creating QVD's in QlikView

Where Exist function when loading two different Sources full loads before creating QVD's

chandu441 — Fri, 23 Mar 2018 10:05:26 GMT

Hi QV World,

Help me in the below scenario if anyone can....

I am having two tables which Table 'A' is loading from DWH and Table 'B' is loading from SAP BW..

Both are full loads daily when it is reloading....

Thing is I need to load the records of Table 'B' with the exist function of a field from Table 'A'.

because if i load Table 'B' whole table then it is taking 4 hours minimum in QMC. So i need to restrict the records with this Table 'B' Field while loading Table 'B'.

Any help from anyone is appreciated...

Thanks

Satya

Re: Where Exist function when loading two different Sources full loads before creating QVD's

tresB — Fri, 23 Mar 2018 10:12:52 GMT

May be like:

Load

Field1

From TableA;

Load

Field2

From TableB where exists (Field1, Field2);

Re: Where Exist function when loading two different Sources full loads before creating QVD's

chandu441 — Fri, 23 Mar 2018 12:03:16 GMT

Hi Tresesco,

The source loading data is from DWH and SAP BW not from QVD's..... so using QV functions we can't load the SAP BW Source tables.