topic Re: Help in loading specified set of data in QlikView

Help in loading specified set of data

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

Hello Sirs ,

Please help me . I want load only those rows of data in Table 2 , which has present in the table 1 of column Top_Grp .

I do not want to using explicit joins .

Help please .

Re: Help in loading specified set of data

stigchel — Tue, 01 May 2018 09:51:17 GMT

You can use where exists:

Table1:

LOAD Top_Grp,

[Base Region],

Pitch

FROM

(ooxml, embedded labels, table is Table);

Table2:

LOAD Top_Grp,

Items,

Date,

Price,

Region,

Defect_History,

Gender_In_Invoice,

F8,

FROM

(ooxml, embedded labels, table is Table2) Where Exists (Top_Grp);

Drop Table Table1;

Re: Help in loading specified set of data

prahlad_infy — Tue, 01 May 2018 09:59:22 GMT

Sir , please explain Where Exists (Top_Grp)

Re: Help in loading specified set of data

duncanblaine — Tue, 01 May 2018 10:09:18 GMT

Hi Prahlad

Using the SampleData you sent, you could do the following or see attached QVW.
I've used KEEP which is not an explicit join, but just keeps everything from one table that has common fields with another.

Hope this is helpful to you.

Table1:

LOAD Top_Grp, [Base Region], Pitch

FROM [Sample Data.xlsx] (ooxml, embedded labels, table is Table);

Table2:

LOAD Top_Grp1 as Top_Grp, Items, Date, Price, Region, Defect_History, Gender_In_Invoice

FROM [Sample Data.xlsx] (ooxml, embedded labels, table is Table);

Table3:

LEFT KEEP (Table1) LOAD * Resident Table2;

DROP TABLES Table2, Table1;

Re: Help in loading specified set of data

stigchel — Tue, 01 May 2018 10:11:01 GMT

That means that it will only load the values of Top_Grp that exist in Table1, in this case Sony and Dell Inc

Re: Help in loading specified set of data

prahlad_infy — Tue, 01 May 2018 10:18:20 GMT

Thank you Sir . But my confusion is that field Top_Grp , exist in Both table and it can not be estimated which Top_Grp (from table 1 or 2 ) to refer

Re: Help in loading specified set of data

duncanblaine — Tue, 01 May 2018 10:39:35 GMT

You don't need to refer to which table Top_Grp belongs to. Qlik automatically links columns which are named the same.

The 'Where Exists' and 'Keep' statements will look at all the data that has already been loaded and only include data that joins via the specified or common field values.