AutonumberHash

[farolito20]

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)

[#2]

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

[farolito20]

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().

[#4]

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

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

Amand Dupretz

[farolito20]

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

[farolito20]

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

[#7]

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

[farolito20]

How to know if data have t_seak?