6 Replies Latest reply: Jun 5, 2014 12:54 AM by Rajendra Nagargoje RSS

    if condition fields from 2 tables

      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!