Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can i resolve this circular reference below.
Thank you
Hi,
it looks to me that your Municipios table stores the name for the code field CD_MUNICIPIO and that you would like to use that name field in the 2 tables "Lojas" and "Clientes". If you only need 1 field from Municipios then you can use a Mapping Load. Mapping tables do not remain in your data model and therefore you will eliminate the Circular Reference:
Note: Do you load your tables with a Preceding Load statement? You need that for this solution.
1) Load the table "Municipios" as a Mapping table by adding the prefix Mapping before your Load statement for Municipios.
2) Give the field CD_MUNICIPIO a unique name in the tables "Lojas" and "Clientes"
3) For your "Lojas" and "Clientes" tables, below your renamed CD_MUNICIPIO field add a field using the ApplyMap statement:
applymap('Municipios', CD_MUNICIPIO_Renamed,'Text if Code does not exist') as [Field Name],
I hope this helps,
Ingo.
Hi Ingo!
Do you have example of this?
Thank you!!
Ingo.