Resolve a Circular Loop

[karelibarcar]

Hi everyone,

Can you please help me how I can resolve this circular reference? because I need the link fc_Interacciones with con_Operacion_Reclamo_tmp2 using Cod_Grupo_Usuario and also the link with con_OperacionOrigen using Descripcion_Gestion. The link between con_OperacionOrigen and con_Operacion_Reclamo_tmp2 using Cod_Operacion is very important.

Do you have any ideas?

[JustinDallas]

Hello Karen Barbarian,

I'm suffering from a similar issue right now.  Generally, I try to either LEFT JOIN or CONCATENATE the tables if that makes sense when considering the datamodel and the questions that will be asked of it.  You could try taking the necessary combinations, and making a master join table, but that doesn't seem to pass the smell test in my opinion.

[karelibarcar]

Exactly, I have already used Concatenate the tables and used link tables but this completely alters the information, it produces too many nulls. Join still avoided using it because I fear that it could alter it even more.

[adityaakshaya]

Hi Karen,

You can use Qualify to remove circular loop here. You can use Qualify <Fieldname>; before the table. this will help to remove circular loop.

Regards,

Akshaya

[karelibarcar]

Thanks for your suggest, Is that the same that rename the field?

[adityaakshaya]

Yes, Either you rename the field or Use Qualify. Using Qualify can help you get schema name before your field name.

Regards,

Akshaya

[karelibarcar]

Oh! but I'm afraid that does not work for me because I need the link to exist, because each Cod_Grupo_Usuario has the same Cod_Gestion and that's why I need to identify the Cod_Grupo_Usuario

[dwforest]

Use ApplyMap to get the Gestion into tmp2?

[Anonymous]

Remove or rename the field COD_Grupo_Usiariou in the _tmp2 table.