topic Re: If exist in QlikView

If exist

Wed, 25 Jun 2014 11:31:04 GMT

Don't know how to do this....

From table A I load the rows ITEM, DESCRIPTION for one specific store

From table B I load the rows ITEMID, COST PRICE, SALES PRICE

In the load script I only want to get the cost price and sales price from the items that was loaded from table A

ITEM in table A is the same as ITEMID from table B

How to do this?

I've tried with "where exist" and left keep but I'm not sure that I use the correct syntax.

Please help

Re: If exist

Wed, 25 Jun 2014 11:39:07 GMT

in order to use where exist your fields have to have the same name. meaning that either you rename ITEM to ITEMID or the opposit way.

regards,

Re: If exist

sasikanth — Wed, 25 Jun 2014 11:39:13 GMT

Use Applymap function

you will get the output

Re: If exist

Gysbert_Wassenaar — Wed, 25 Jun 2014 11:39:55 GMT

Like this:

TableA:

Load ITEM, DESCRIPTION from ....

left keep (TableA)

TableB:

Load ITEMID as ITEM, COST PRICE, SALES PRICE from ...

Re: If exist

its_anandrjs — Wed, 25 Jun 2014 11:42:14 GMT

Try to load your table like

table A

Load

ITEM, DESCRIPTION

From Location;

table B

Load

ITEMID, COST PRICE, SALES PRICE

From Lcoation

Where Exists(ITEM,ITEMID);

Re: If exist

PradeepReddy — Wed, 25 Jun 2014 11:43:47 GMT

If you want data

1) 2 seperate tables, use the 'Left Keep'

2) in single table, use the 'Left join'

Re: If exist

sasikanth — Wed, 25 Jun 2014 11:44:35 GMT

Load * from

TAB_B;

TAB_A:

load * Inline [

ITEM,DESCIPTION

.];

Load

ApplyMap(ITEMID,Descrption) as ITEM,

Costprice,

Selling price

resident TAB_B;

Re: If exist

its_anandrjs — Wed, 25 Jun 2014 11:49:48 GMT

Or you can use simple join if you want data based on the first table then use join with (Left,Right,Inner) based on the requirement.

tableA:

Load

ITEM, DESCRIPTION

From Location;

Join

tableB:

Load

ITEMID, COST PRICE, SALES PRICE

From Lcoation

Where Exists(ITEM,ITEMID);

Re: If exist

Wed, 25 Jun 2014 12:10:54 GMT

You can use exists like this:

Load ITEM,

DESCRIPTION

From ...;

Load

ITEMID,

COST,

PRICE,

SALES,

PRICE

From ...

Where exists(ITEM,ITEMID);

/Ida