Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
I reload script in Qlikview it show circular references. I do not know how to avoid that circular references I want to avoid that circular references please tell me out how to avoid circular references in qlikview. I attached snipping files below this box.
Regards:
Madhu
Rename your field name which is creating circular references or make the composite keys from the keys
1. Rename the fields which are creating the circular references.
2. Join two tables based on the keys and use only two tables join the tables based on the relation primary key table or transaction table.
Eg:-
city_car:
LOAD * Inline
[
city,car
Mum,SomeCar
];
Left Join(city_car)
person_car:
LOAD * Inline
[
car,person
SomeCar,A
];
Left Join(city_car)
person_city_Master:
LOAD * Inline
[
city,person
Mum,A
];
Note:- There are many ways to doing the same problem.
Thanks Anand chouhan .I want to use Loosen Table statement please tell me out and explain with example chouhan.
Hi madhu,
Try loading one of the tables twice changing one of the fields names each of the times.
Cheers
Carlos
Why are you splinting your data anyway?
If you need to change the name try like this:
Person_car
LOAD
car as Pcar,
Person as Pperson
FROM....
Hi,
Use Loosen table with one of the tables for avoiding the circular references when you reload by above script you dont get the message circular reference.
city_car:
LOAD * Inline
[
city,car
Mum,Hyundai
];
//LOOSEN Table city_car;
person_car:
LOAD * Inline
[
car,person
Hyundai,A
];
person_city:
LOAD * Inline
[
city,person
Mum,A
];
LOOSEN Table person_city;
Very nice description:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references
by henric cronström
http://community.qlik.com/people/hic
hope this helps
regards
Marco
For more simplify you can break table into more informative ways and use that tables to normalize the tables. In the documentation Henric explain this also take a look at the sample load script for this.
city_car:
LOAD * Inline
[city,car
Mum,Hyundai];
/////
car_details:
LOAD
city,car as [Car in the city]
Resident city_car;
city_Details:
LOAD
city as [City of the Car],car
Resident city_car;
DROP Table city_car;
/////
person_car:
LOAD * Inline
[car,person
Hyundai,A];
person_city:
LOAD * Inline
[city,person
Mum,A];