topic Re: AutonumberHash in QlikView

AutonumberHash

farolito20 — Thu, 03 Jan 2013 14:12:54 GMT

It's possible to know which column compose a key made with autonumberhash?

For example.. Before my key was AutnumberHash(t_bpid,t_nama,t_ccur)

Now my key is AutnumberHash(t_bpid,t_nama,t_seak,t_ccur)

Re: AutonumberHash

Thu, 03 Jan 2013 14:39:18 GMT

Hello,

If you wanna know what fields compose your key, you must check this in your script.

After the reload, you can't see this in the designer.

Amand Dupretz

Re: AutonumberHash

farolito20 — Thu, 03 Jan 2013 14:53:57 GMT

Damn, 😕 my problem is that I load my data and store it in qvd, but to avoid duplicates, I used a key. But now I wanna add a new key and put null in that column to old information, so I think that maybe I can do a if like this:

DimOld:

LOAD

%KeyCustomer,

t_bpid,

t_bpid as CustomerNumberCHK1,

t_nama,

if($(ScriptErrorCount)>0 or t_seak=null(),null(),t_seak) as t_seak,

t_ccur,

ValidFrom,

ValidTill,

MostRecent,

Autonumberhash256(t_bpid,t_nama,t_seak,t_ccur) as Checksum

FROM DimCustomers_Day0.qvd (qvd);

if t_seak is not found I can put null().

Re: AutonumberHash

Thu, 03 Jan 2013 15:03:19 GMT

I don't understand where is the problem...

Why do you use this condition : if($(ScriptErrorCount)>0 ?

Amand Dupretz

Re: AutonumberHash

farolito20 — Thu, 03 Jan 2013 15:05:08 GMT

Because in my table DimCustomers_Day0.qvd (qvd); not exist t_seak, so if qv found an error, I want the value null() to t_seak

Re: AutonumberHash

farolito20 — Thu, 03 Jan 2013 15:06:03 GMT

I want that if not exist t_seak in the table, put null() , else put the value of t_seak

Re: AutonumberHash

Thu, 03 Jan 2013 15:12:18 GMT

Okey, and your condition works ?

Else I think you can do two Load :

- First : old data (without t_seak)

- Second : concatenate (old data) with new data (with t_seak)

Amand Dupretz

Re: AutonumberHash

farolito20 — Thu, 03 Jan 2013 15:34:32 GMT

How to know if data have t_seak?