Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
What links dimSales to the table that contains OrderCreateName? Is there a field in common like "OrderId"?
-Rob
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!
Is there any way to do this as a calculated demension?
For example
Aggr( if( SalesPersonName='Smith, Jeff' ,OrderCreateName,SalesPersonName),SalesPersonName
Thanks