This content has been marked as final. Show 2 replies
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.
thought i would add the actual script
Message was edited by: Michael Gauntlett adding in script