Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm in the process of creating a data model for our NetSuite application, however I'm coming across a data looping messaging when reloading the model
In NetSuite all the transactions like Opportunity, Quote etc are all stored in one table, in QlikView I have split them off into separate "types" so I can join them, this works
I join on "Transaction Lines" which is a table that stores all the lines on these transactions, here the loop occurs because I join this table to all the transaction tables above, the idea is to get the line items of each of the types of transactions because they could vary between types
How would I resolve this loop?
I can keep the transactions in one table, but then how do I link the rows to themselves as there are relationships in this one table
Many Thanks
A screenshot would really help, but I think what you are most likely running into is a circular reference. Here is a link to the Design Blog area and a post on how to deal with those:
https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332
Regards,
Brett