topic Calling two tables in the script in QlikView

Calling two tables in the script

Tue, 05 Jun 2012 20:12:07 GMT

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

Calling two tables in the script

rwunderlich — Wed, 06 Jun 2012 00:21:54 GMT

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

-Rob

Calling two tables in the script

Wed, 06 Jun 2012 13:23:44 GMT

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!

Re: Calling two tables in the script

Wed, 13 Jun 2012 19:31:21 GMT

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

For example

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

Thanks