Calling two tables in the script

[#1]

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!!

[rwunderlich]

What links dimSales to the table that contains OrderCreateName? Is there a field in common like "OrderId"?

-Rob

[#3]

Hi Rob,

Thanks for your response. SalesPersonName and OrderCreateName are actually on opposite ends of a star schema. There are two tables in between them. I have attached a diagram. I appreciate any insight. Thanks!

[#4]

Is there any way to do this as a calculated demension?

For example

Aggr( if( SalesPersonName='Smith, Jeff' ,OrderCreateName,SalesPersonName),SalesPersonName

Thanks