Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
karelibarcar
Contributor III
Contributor III

Resolve a Circular Loop

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?

rc.png

8 Replies
JustinDallas
Specialist III
Specialist III

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
Contributor III
Contributor III
Author

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
Creator III
Creator III

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
Contributor III
Contributor III
Author

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

adityaakshaya
Creator III
Creator III

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

Regards,

Akshaya

karelibarcar
Contributor III
Contributor III
Author

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
Specialist II
Specialist II

Use ApplyMap to get the Gestion into tmp2?

Anonymous
Not applicable

Remove or rename the field COD_Grupo_Usiariou in the _tmp2 table.