Loading additional fields from an external spreadsheet is leading to worng data

[#1]

HJi,

I have a report that loading data from 3 QVDs and it works fine..

Some of the fields are ManufactLabel, FY, Month, Rev, Margin...

Now I am trying to load additional data from excel spreadsheet and it has the following fields:

ManufactLabel, FY, Month, and EngCost...

I assumed that QlikView will join the tables but it is getting me error One or more loops have been detected in your database..

Anybody can help me on this?

Attached is the tables view

Thxs

[#2]

Also, note that i have done left join for the excel file hoping it will fix the issue but it didn't!

Thxs

[jagan]

Hi,

Your datamodel has Circular loop,

A circular loop is occurred when there is a mapping between

Table A -> Table B -> Table C -> Table A

Remove mapping between Table C and Table A, then you won't get this type of error.

There are many posts regarding loops in the forum.

Hope attached PDF helps you.

Regards,

Jagan.

[#4]

Thxs for the replay..

I know that the error is happening because of the mapping but i don't know how to fix it as I cannot get rid of any of the fields or change their names

Thxs

[CELAMBARASAN]

Hi,

     Better join the Details of one table to any one of another 2 tables.

     In your case Join Display Month table to QvdLoad1 table or QvdLoad2 table.

     And also try to avoid Sync tables.

Celambarasan

[jagan]

Hi,

Join DisplayMonth table to QvdLoad1 and QvdLoad2 tables like below

LEFT JOIN(QvdLoad1)

LOAD

     *

FROM DisplayMonth;

LEFT JOIN(QvdLoad2)

LOAD

     *

FROM DisplayMonth;

This eliminates DisplayMonth table from the Data Model.  So the loop is eliminated.

Regards,

Jagan.

[#7]

I have tried that.

I was able to get rid of the loop but the nrs are not correct anymore

[#8]

Like I am getting away different Nrs from what they should be