if condition fields from 2 tables

[#1]

Hi, I have an if condition that contains fields from 2 different tables so I tried to concatenate the tables and when run, I received error message saying the field is not found. This is my current script:

INVENT:

LOAD *, IF(INVENTLOCATION='BTSTORE',REORDERPOINT) AS 'ROP(BT)';

SQL SELECT

.

.

.(OTHER FIELDS)

.

ORDERQTY

INVENTLOCATION

.

.

FROM <FILENAME>;

CONCATENATE(INVENT)

SQL SELECT

.

.

.

REORDERPOINT

.

.

FROM <FILENAME>;

Basically I want to create a column that reads from 2 tables.

Thanks!

[miikkaqlick]

Hi!

Make first that concatenation and after that load if-statement.

Invent:

Load

     *,

     If(.... ) as 'ROP(BT)'

;

Load

      *

SQL Select * From Filename1

Concatenate

Load

      *

SQL Select * From Filename2

When you are doing if, you dont have required fields at that point.

Br,

Miikka

Climber Finland