three fields in one

[pgalvezt]

Hi, I trying to join 3 tables "Castigo"  "RecCastigo" and "ComercioCartera" the field key is Cc_Cli (Customer Code) But this Cc_Cli in "Castigo" has another name and the same thing for "RecCastigo" so I concatenated "Castigo" and Rec.Castigo"  and renamed into "Castigo" the field CC_CLI as CodComercio, When I Do clic in Cod Comercio "Castigo" and " RecCastigo" Show me the real values so works fine. But I have to join another table call "ComercioCartera" This table has a Cc_Cli too when I renamed like CodComercio (Reference Circular appears) When Tried with applymap and concatenate (appears Synthetics Keys) and the values change completely. Wht I want is to do clic in "CodComercio" or "Comercio" and QlikView shows the real values. I don't want to 2 "Comercio"

Please help with this Im really stuck with this issue.

Thank you.

[bgerchikov]

You have Exit Script; statement on line 64. Remove it

[pgalvezt]

I commented the exit script.

[bgerchikov]

Hey,

I cannot find out the problem without having source files. Can you upload them?

[pgalvezt]

I can't do that I appreciate your help. Im going to open a new discussion. I know is a difficult requirement.

Thanks again