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

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

Thu, 12 Apr 2012 13:29:03 GMT

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

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

Thu, 12 Apr 2012 13:53:16 GMT

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

Thxs

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

jagan — Thu, 12 Apr 2012 13:53:51 GMT

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.

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

Thu, 12 Apr 2012 14:06:13 GMT

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

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

CELAMBARASAN — Thu, 12 Apr 2012 14:18:30 GMT

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

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

jagan — Thu, 12 Apr 2012 14:38:59 GMT

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.

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

Thu, 12 Apr 2012 14:51:23 GMT

I have tried that.

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

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

Thu, 12 Apr 2012 15:23:26 GMT

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