Correct Description for an Item

[#1]

Hi

We have a Head Office in Johannesburg with a few branches which operates independently. When items are loaded, the description varies for the same item for the branches.

How do I create a formula to always show  Head Office 's description. If an item does not exist in Head Office , then it should take the description of the branch.

In the table below, the solution i am looking for is in the last column - "Correct Description".

So, for eg, item code "B" , the correct descrition should be Banana's , which is the same as Head Office Description.  For Item code "C", because Head Office does not have the item, it must take the description of Port Elizabeth, which is "Carrot".

Branch Name	Item Code	Description	Correct Description
Durban	B	Banana	Banana's
Head Office	B	Banana's	Banana's
Cape Town	B	Bananas (Pack)	Banana's
Port Elizabeth	C	Carrot	Carrot
Durban	P	Pear	Pear
Head Office	A	Apple's	Apple's
Port Elizabeth	A	Apples (10)	Apple's
Cape Town	A	Apples (Pack)	Apple's
Durban	A	Apple	Apple's

Please help

regards

Nayan

[marcus_sommer]

This could be solved with:

mapping ( load-befehl |select-befehl )

Mapping1:

MAPPING LOAD * INLINE [
x,y
US,USA
U.S.,USA
America,USA
Amerika,USA];

- Marcus

[#3]

Hi Marcus

Thanks.  Will try it out.

Will this formula apply to many items.  Because in my actual Qlikview Model, I have over 10 000 items like these.

kind regards

Nayan

[marcus_sommer]

Yes it will, no problem. You will need time these values to match (manually?) for mapping-table ...

- Marcus