topic Anonymise Names with Unique Ref in QlikView

Anonymise Names with Unique Ref

Anonymous — Tue, 01 Aug 2017 10:45:41 GMT

I want to replace a name with a unique reference number. Is this possible?

see example below

Date	Name	Amount	Annon
01/04/2017	Sam Smith	100	1234
02/04/2017	Joe Bloggs	50	5678
02/04/2017	Sam Smith	150	1234
03/04/2017	Peter Potter	20	9876
03/04/2017	Joe Bloggs	100	5678

I want to create 'Annon' column based on the name See above.

Any thoughts?

Regards

Phil

Re: Anonymise Names with Unique Ref

ahaahaaha — Tue, 01 Aug 2017 10:52:19 GMT

Hi Phil,

May be use Autonumber(Name)?

Regards,

Andrey

Re: Anonymise Names with Unique Ref

Kushal_Chawda — Tue, 01 Aug 2017 10:53:02 GMT

try below

1000+rowno() as Annon

Re: Anonymise Names with Unique Ref

Chanty4u — Tue, 01 Aug 2017 10:55:59 GMT

just try this

aa:

LOAD * INLINE [

Date, Name, Amount, Annon

01/04/2017, Sam Smith, 100, 1234

02/04/2017, Joe Bloggs, 50, 5678

02/04/2017, Sam Smith, 150, 1234

03/04/2017, Peter Potter, 20, 9876

03/04/2017, Joe Bloggs, 100, 5678

];

Result:

LOAD *

AutoNumber(Name) as Result

Resident aa;

Re: Anonymise Names with Unique Ref

md_qlikview — Tue, 01 Aug 2017 10:58:10 GMT

Try using Autonumebr function

Eg. Autonumber(FieldName) as Annon

Re: Anonymise Names with Unique Ref

sunny_talwar — Tue, 01 Aug 2017 11:01:33 GMT

Although AutoNumber is a quick and easy option, here is another one which will probably give better performance on larger dataset

Table:

LOAD Date,

Name,

Amount

FROM ....;

FinalTable:

LOAD Date,

Name,

Amount,

If(Name = Previous(Name), Peek('Annon'), RangeSum(Peek('Annon'), 1)) as Annon

Resident Table

Order By Name;

DROP Table Table;

Re: Anonymise Names with Unique Ref

tomasz_tru — Tue, 01 Aug 2017 11:02:25 GMT

Autonumber can give you different representation of Name when reloading the data. If you want to have permanent Name<>Annon connection, use hashing functions: Hash128 ‒ QlikView

Tomasz

Re: Anonymise Names with Unique Ref

Anonymous — Tue, 01 Aug 2017 11:44:24 GMT

So Simple. Thanks guys !