Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

regarding Resident Load

Hi this mahesh new to qlikview  i had loaded table from from excel like this

Old:

LOAD country,

     date,

     price,

     productid,

     source

FROM

(biff, embedded labels, table is Sheet1$)   ;

i want use filter condition and want to derive new table

can i write like this  from resident  after re loading i  am unable to see New table. how to get New table

New:

load * resident old  where source='online' and country='ind'

please correct if my script is wrong thanking you in advance

1 Solution

Accepted Solutions
Master III
Master III

Two tables that have exactly the same columns will automatically concatenate. As a result the new table will never exists and the rows will just be added to the old table.

Two solutions:

If you do not want two tables, but only want to filter, just add the where clause to the initial load:

Old:

LOAD country,

     date,

     price,

     productid,

     source

FROM

(biff, embedded labels, table is Sheet1$)

where source='online' and country='ind';

Alternatively, you can add the noconcatenate statement to the 2nd load:

New:

noconcatenate

load * resident old  where source='online' and country='ind';

Keep in mind that when two tables have more then 1 column in common you get a synthetic key; not what you want.

May you live in interesting times!

View solution in original post

2 Replies
Master III
Master III

Two tables that have exactly the same columns will automatically concatenate. As a result the new table will never exists and the rows will just be added to the old table.

Two solutions:

If you do not want two tables, but only want to filter, just add the where clause to the initial load:

Old:

LOAD country,

     date,

     price,

     productid,

     source

FROM

(biff, embedded labels, table is Sheet1$)

where source='online' and country='ind';

Alternatively, you can add the noconcatenate statement to the 2nd load:

New:

noconcatenate

load * resident old  where source='online' and country='ind';

Keep in mind that when two tables have more then 1 column in common you get a synthetic key; not what you want.

May you live in interesting times!

View solution in original post

Creator
Creator

Hii okg

  Thanks  so much