Re: Allocating Order Level Information to Line level
Hi Karla & swuehl,
Please find attach excel file of an example of what i am trying to achieve. In the excel file i have a header tab with a simple transaction with couple of fields. And in the Item tab i have the item level details of the transaction happened in the header/order level.
What i would like to do is, get all the fields from Header level and allocate them in the item level and make a unified fact table. I think Inner joining the Item table with Header table would do the trick but both table in real application are having more than 5 million records and inner joining is freezing qlikview in my desktop.
What would be the best way to allocate the necessary fields from Header table to Item table and make a unified Fact table? Also, please let me know if there is any best practice in this situation.