if condition fields from 2 tables

Thu, 05 Jun 2014 03:19:06 GMT

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!

Re: if condition fields from 2 tables

miikkaqlick — Fri, 12 Sep 2014 09:33:30 GMT

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

topic if condition fields from 2 tables in QlikView

if condition fields from 2 tables

Re: if condition fields from 2 tables