topic Re: load atuo compare in QlikView

load atuo compare

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I have two tables in my Load script . Which is making the link using 'Customer ID' Now Table A has lots of data ,

But i want to load only that data whiere the CutomerID of Table B matches with the Customer ID of Table A .

How can I achive this ? I know i can use where function and need to specify manaul entries of the Customer ID's which is a headache.

Please suggest how can I make this automated.

Table A:

Load

Department,

Section,

Sales,

ID,

Region,

Customer_ID

From......

Table B:

Load

Business,

Products,

Parcels,

Category,

Customer_ID,

From....

Thanks in advance

Re: load atuo compare

zhadrakas — Wed, 29 Jul 2020 11:58:13 GMT

use exists() function in where clause. this also keeps the optmized load.

Exists - Skriptfunktion ‒ QlikView

A: Load Department, Customer_ID B: Load A, B, Customer_ID where exists(Customer_ID)

Re: load atuo compare

smilingjohn — Wed, 29 Jul 2020 12:02:58 GMT

I am confused ..

I have so many fields in Table A how can i write ur sript example ?

Re: load atuo compare

zhadrakas — Wed, 29 Jul 2020 12:05:26 GMT

just add this line in the second load Statement.

where exists(Customer_ID)

if you want to check more fields go like

where exists(Customer_ID) and exists(Department)

Re: load atuo compare

smilingjohn — Wed, 29 Jul 2020 12:30:41 GMT

Thanks for the reply

PLease find the attachment of the QVW.

I want to keep my table and the fields as it is .

In tableA there are 26 Customer ID and in Table 2 there are only 9 customer ID .

I want to load Table A data related to only 9 Customer ID's of Table B .

Thanks

Re: load atuo compare

zhadrakas — Wed, 29 Jul 2020 12:33:56 GMT

in that case just load table B first and then Load Table A with where exists()

TableB: LOAD CustomerID, ITComp, Are, Sales, Gravity FROM [C:\APP\TestData.xlsx] (ooxml, embedded labels, table is Sheet4) ; TableA: LOAD CustomerID, Deoartment, Product, Region, Incometx, FloorID FROM [C:\APP\TestData.xlsx] (ooxml, embedded labels, table is Sheet1) where exists(CustomerID);