Solved: Re: Loops warning!!! - Qlik Community

Report Inappropriate Content · ‎2014-09-03

Hi,

Can any one emplane the warning popup below and please emplane how to avoid the warning..

miikkaqlick · ‎2014-09-03

Hi!

You need to change your datamodel a little.

From that point on script:

tmp_STYLE_MASTER:

Load * Resident STYLE_MASTER;

Join (STYLE_MASTER)

Load * Resident Factory;

Join (STYLE_MASTER)

Load * Resident Buyer;

Join (STYLE_MASTER)

Load * Resident Locations;

Join (STYLE_D_MCT)

Load * Resident tmp_STYLE_MASTER;

Drop tables STYLE_MASTER, Factory, Buyer, Locations, tmp_STYLE_MASTER;

Last join is a bit of a question mark. That should simplify your datamodel and if that last join works you dont have any more circular references.

Br,

Miikka

Climber Finland

View solution in original post

alexandros17 · ‎2014-09-03

if it is possible avoid loops doing join (Left or outer) between tables where loops appears. I can help ypou more if you attach the tables view.

Report Inappropriate Content · ‎2014-09-03

I knew from where the warning is popping up but the thing is I need BUY and STYLE_NAME as primary key I need both to be linked. please find the view below

tresesco · ‎2014-09-03

See if these help:

circular-references

How circular reference can be avoided?

vinay_hg · ‎2014-09-03

remove the sync1 table ids by renaming it to other names like styleid as style_id then loop will be remove.

Report Inappropriate Content · ‎2014-09-03

how do I rename, it is a table created by qlikview

vijay_iitkgp · ‎2014-09-03

Hi , In script you can rename the fields causing circular reference.

STYLE_ID as STYLE_ID1 or any suitable name

Report Inappropriate Content · ‎2014-09-03

yeah but I need all STYLE_IDs and BUYs to be linked

vijay_iitkgp · ‎2014-09-03

Then Please create concatenated Key by Using STYLE_ID&BUY to link and rename other fields.

avinashelite · ‎2014-09-03

Hi Mafaz,

Can you please post the app.