topic Need help on synthetic keys! in QlikView

Need help on synthetic keys!

Thu, 25 Feb 2010 18:37:26 GMT

Hi,

I need the output of the table in the file as it is, but I am not able to get rid of the synthetic key in the script.

The problem is that I need the table to show 0 hours even when there is no record.

I solved it but I don´t like the solution.

Any suggestions??

Thanks

Need help on synthetic keys!

Fri, 26 Feb 2010 12:25:25 GMT

Anyone..?

Need help on synthetic keys!

Fri, 26 Feb 2010 13:04:11 GMT

Hi,

Try that one ;


planning:
qualify "Quincena","Horas";
LOAD * INLINE [
 Quincena, IDlink, Horas,
 JUN08Q1, 0001, 2
 JUN08Q2, 0001, 8
 JUN08Q2, 0001, 25
 JUN08Q1, 0002, 1
];

Im not surely understand what is the main purpose of your report but if the main problem was synthetic key you should use qualify or alias to get rid off systentic key.

Best Regards,

Önder ALTINBILEK

Need help on synthetic keys!

Fri, 26 Feb 2010 13:19:04 GMT

You can also create a composite key consisting of the fields Quincena, Horas and IDlink.


HORAS0:
Load
 Quincena&'|'&Empleado&'|'&Horas AS CompKey,
 NQuincena,
 Quincena,
 Horas,
 HorasMAX,
 Empleado as IDlink
resident HORAS0temp;
Drop table HORAS0temp;

planning:
LOAD * INLINE [
 CompKey
 JUN08Q1|0001|2
 JUN08Q2|0001|8
 JUN08Q2|0001|25
 JUN08Q1|0002|1
];

You can still add the fields as separate fields to the inline table of course. But change the names so they are not the same in both tables.

Need help on synthetic keys!

Mon, 01 Mar 2010 09:28:12 GMT

Thanks all for your help. I fugured out how to solve the issue thanks to your answers.

Need help on synthetic keys!

Tue, 29 Jun 2010 12:06:18 GMT

Hi Sjoerd,

Can you please share how you resolved this issue. I am also facing synthetic key problem. Let me know how to resolved the same.

Need help on synthetic keys!

pgalvezt — Fri, 20 Apr 2012 15:26:58 GMT

Hi Sjoerd,

Can you please share how you resolved this issue. I am also facing synthetic key problem. Let me know how to resolved the same.