Creating a flag field from two separate QVD

[mikegauntlett]

Hi All,

In short I have two fields 'country' from a country.QVD and 'order_booked' from orders.QVD.

They are in two differing sections of the load script

Want I want to be able to get to, is to create a flag field

When 'Country'=UK and 'Order_booking'='false'.

Everytime I try if(country='UK',if(Order_Booked='false',1,0),0) as uknotbookedflag

when loading the data it states that one or the other field does not exist.

Any Ideas

thought i would add the actual script

Message was edited by: Michael Gauntlett adding in script

[sunny_talwar]

You will have to bring the two tables into a single table either using a join or Lookup or ApplyMap and then do the if statement you are looking to do

[mikegauntlett]

HI sunny

How do those methods work, sorry  new to qliksense.

What is the syntaxes for the apply map function