3 Replies Latest reply: Jun 13, 2012 3:31 PM by jhoffef15 RSS

    Calling two tables in the script

      Hello,

       

      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!

       

       

      Load

                *,

                if(SalesPersonName='Smith, Jeff' ,OrderCreateName,SalesPersonName) as Name_Master

       

                Resident dimSales;

       

       

      Thanks!!