Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one emplane the warning popup below and please emplane how to avoid the warning..
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
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.
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
remove the sync1 table ids by renaming it to other names like styleid as style_id then loop will be remove.
how do I rename, it is a table created by qlikview
Hi , In script you can rename the fields causing circular reference.
STYLE_ID as STYLE_ID1 or any suitable name
yeah but I need all STYLE_IDs and BUYs to be linked
Then Please create concatenated Key by Using STYLE_ID&BUY to link and rename other fields.
Hi Mafaz,
Can you please post the app.