Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loops warning!!!

Hi,

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

error.jpg

10 Replies
miikkaqlick
Partner - Creator II
Partner - Creator II

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