2 Replies Latest reply: Sep 3, 2017 6:28 AM by Michael Gauntlett RSS

    Creating a flag field from two separate QVD

    Michael Gauntlett

      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

       

      2017-09-03_11-27-05.jpg

       

      Message was edited by: Michael Gauntlett adding in script