Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want ask how to link "Accounts" and "Patients".But all dimension must link exactly from picture. The problem is between "Accounts" and "Patients" because the fields c and city,s and state,z and zip are the same.I don`t know how i link them without loop. Thank you
Hi,
Use Concatenate in the script for some of your tables.
BR
Ariel
You'll have to rename L2 in either txBilling or Treat or rename MEDNO in either Treat or Patient or rename ACCTNUM in either Accounts or txBilling.
for removing loop
there are many ways--
1- by join between two tables
2- by chage alies that is rename the field name
3-- by use the concatenate between two tables
The problem is between "Accounts" and "Patients" because the fields c and city,s and state,z and zip are the same.I don`t know how i link them without loop. Thank you