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: 
Not applicable

Loading extra table from Excel causing loop error

Hi,

I am loading data from several QVDs and everything works fine.(Fy, MonthName, Lebel are some of the fields coming from different qvds)

I tried to add an excel file to load additional fields (Lebel, FY, MonthName and EngCost)..

Having all this fields together is causing circular loop.

May you please help me on figuring out how to get rid of it and keep the correct data showing up.

Thxs

7 Replies
Not applicable
Author

Hello,

I think you can get rid of these circular references by using one of these methods , loosen table or using only one primary key to connect to one table.when you have many primary keys  connecting to several different tables create loops and syn tables. For that reason the application eats more memory.

Hope  it will give you a clue in which direction to go.

Regards,

Salman

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi Badr.

Try and concatenate the excel file to the first table.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Not applicable
Author

Hi,

Thank you for the quick replay..

I have tried that but it messed up the data..

it is not linking the data right

Attached is the document if you would like to take a look on it.

If you comment the concatenate on with QVDLoad1 ..then the data is right

but I need to add the a monthly cost for every label.

Thxs..

Not applicable
Author

Attached is the data view as well.

Thxs

Not applicable
Author

Hello,

please try to remove these fields from QVD2

Feature, Model,Manufacture,Machine, Monthname and then try to reload the application from script level. hope this will work.

Regards,

salman

Not applicable
Author

I tried that..

It only reduce the SYN table fields but it doesn't fix the issue.

The problem is happening because I am loading Manufact Lbl, MonthName, FY and ENG Cost from Excel Table..

QVD1 has ManufactLbl

Qvd2 has MonthName and FY

I tried to concatenate QVD1 and QVD2 but it didn't help

I also tried to Left Join QVD1 and QVD2 but It didn't help as well..

I am getting wrong data ..

Regards,

Badr

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi again Badr.

Do you know what you want to do with the data in the two QVD:s?
How are they logically linked?
Do you know the difference between a join and a concatenation?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.