If Then Question

[#1]

I have the following data in Excel that I want to Load into Qlikview

Order     Operation     Value

12345     0060               3

12345     0061               5

12346     0060               10

12347     0060               5

12347     0061              11

What I am trying to do is have it load everything that has 0060 with its order and value, but if it has an 0061 I want the value from it and not from 0060.  What is the best way to do that?

thanks for your help

Marcia

[hic]

I would probably do it like

Temp:

Load Order as TempOrder, Operation, Value From <Data> ;

Final:

Load TempOrder as Order, Operation, Value

          resident Temp

          Where not Exists(Order, TempOrder)

          Order By Operation Desc;

Drop Table Temp;

HIC