topic Re: Model Solution in QlikView

Model Solution

fkeuroglian — Thu, 29 Oct 2015 13:00:48 GMT

Hi Expert

I have this situation with a model, what would be the best solution?

i think about a link table, i can delete any field of this tables

thank you a lot

Fernando

Re: Model Solution

Anonymous — Thu, 29 Oct 2015 13:02:57 GMT

i would concatenate the targeta and detalle table into one fact table

Re: Model Solution

Thu, 29 Oct 2015 13:12:37 GMT

The better way is concatenate the table, It is more performance than Linktable.

Regards

Marcos Freire

Re: Model Solution

Anonymous — Thu, 29 Oct 2015 13:16:48 GMT

Hi Fernando,

Maybe you can join the tables and make them into one fact table. The table REMITO can serve as a dimension. This will than be connected to the fact table by concatinating the to fields and making them a key. You would do the same on the fact table. So something like: (PROD_SQ_COD & 'I' & TARJ_SQ_COD) as %REMITO_KEY