This content has been marked as final. Show 3 replies
I run a binary load to pull multiple tables in QV. In the script (after the binary) I want to create a feild that looks at the "SalesPersonName" feild and if it equals a certain name I want the output to be "OrderCreateName". Otherwise I want "SalesPersonName" as the output. SalesPersonName and OrderCreateName are on two separate tables. Here is the current script I am trying with out any luck. Any suggestions would be great!
if(SalesPersonName='Smith, Jeff' ,OrderCreateName,SalesPersonName) as Name_Master