topic Re: Fact tables to avoid loops and synthetic keys in QlikView

Fact tables to avoid loops and synthetic keys

Fri, 30 Jan 2015 07:42:38 GMT

------------------------------------------------------------------------------------------------------------------

Like this Output I should Get please help me.

Re: Fact tables to avoid loops and synthetic keys

alexandros17 — Fri, 30 Jan 2015 07:50:20 GMT

You could do ... (I give the idea, convert in correct syntax)

load * resident main

ledt join

load * resident product Group

and you could join the 2 table records

oad * resident record

join

load * resident record-1

what has happened now?

let me know

Re: Fact tables to avoid loops and synthetic keys

its_anandrjs — Fri, 30 Jan 2015 08:02:28 GMT

Hi,

Use composite keys here in your data model there are many fields are same in the tables and that is the reason you get many synthetic keys and the synthetic tables also in the data model. Do work on the remove the synthetic keys to rename them or create the composite keys from they and join them.

Load Description as Desc,* From Main;

Left Join

Load LocationID&_&ProductID as Key, ProductID as ProdID,* Record;

Regards

Anand

Re: Fact tables to avoid loops and synthetic keys

Fri, 30 Jan 2015 08:10:51 GMT

Hi hello

My Actual DATA which is shown Above is like this .From this i want the output like this

Please help me this

Thanks in Advance