how to remove loop

[Anonymous]

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

[ariel_klien]

Hi,

Use Concatenate in the script for some of your tables.

BR

Ariel

[Gysbert_Wassenaar]

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.

[#4]

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

[Anonymous]

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