Loading extra table from Excel causing loop error

[#1]

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

[#2]

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]

Hi Badr.

Try and concatenate the excel file to the first table.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

[#4]

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

[#5]

Attached is the data view as well.

Thxs

[#6]

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

[#7]

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]

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.