connect in back-end a value with one table if there is a field, if not connect with other table

[andreascansani1]

I'm newbie in qlikview report  I would like to create a value that is connect with two tables , when there is a field in  "account name " connect with the customer tables, if there  isn't a value in the field connect with salesman_name from sales name.

I post a screenshoot of what I would to do in order to be more clear 

[rubenmarin]

Hi, you can use a mpping table to assign a value, something like:

mapSalesman:
Mapping LOAD
  ID_Salesman,
  Salesman_Name
From... Sales_Man.qvd (qvd);

// With the mapping table ready you can load the main table:
Load
  Id_Customer
  ...
  If(IsNull(Account_Name)
    ,ApplyMap('mapSalesman',ID_Salesman)
    ,Account_Name
  )  as Key_Account_Manager,
  ...