Help needed in Exists function

[Anonymous]

Hi,

I have a table with two columns as below:

Table1:

DRG,

Wave

I have a second table with two columns FINALDRG, COST. The FINALDRG in the second table is same as the DRG in the first table.

So I have renamed the FINALDRG as DRG and the table looks like below:

Table2:

FINALDRG as DRG

COST

Now I have to load the table2 but with a condition. And the condition is, table2 should be loaded only with the DRGs which are loaded in table 1. How to do that? I tried using exists function but it is not working.

I have used the below script:

Table2:

Load * where exists(FINALDRG,DRG) but it is not working.

Thanks

[Vegar]

You have switched the parameters. Try

Table2:

Load * where exists(DRG, FINALDRG)

[swuehl · Accepted solution]

Try

Load * where exists(DRG, FINALDRG);

The field to check comes first.

[Anonymous]

Thanks Stefan, this worked

[Anonymous]

Thanks Vegar. This worked