topic Loading extra table from Excel causing loop error in QlikView

Loading extra table from Excel causing loop error

Fri, 13 Apr 2012 14:37:34 GMT

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

Loading extra table from Excel causing loop error

Fri, 13 Apr 2012 14:44:36 GMT

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

Loading extra table from Excel causing loop error

magavi_framsteg — Fri, 13 Apr 2012 14:45:20 GMT

Hi Badr.

Try and concatenate the excel file to the first table.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Loading extra table from Excel causing loop error

Fri, 13 Apr 2012 14:57:05 GMT

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..

Re: Loading extra table from Excel causing loop error

Fri, 13 Apr 2012 15:06:52 GMT

Attached is the data view as well.

Thxs

Loading extra table from Excel causing loop error

Fri, 13 Apr 2012 15:25:30 GMT

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

Re: Loading extra table from Excel causing loop error

Fri, 13 Apr 2012 16:19:32 GMT

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

Re: Loading extra table from Excel causing loop error

magavi_framsteg — Thu, 19 Apr 2012 16:18:35 GMT

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.