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




      Message was edited by: Michael Gauntlett adding in script