topic Re: AutoNumber() as Key in QlikView

AutoNumber() as Key

datanibbler — Wed, 01 Apr 2015 09:31:21 GMT

Hi,

I am currently working on an app which is going to be quite big as there is a lot of data.

I thus tried to make it somewhat less resource-heavy by using the AutoNumber() function to replace

an alphanumeric key by a numeric.

To check if the linking works, I kept the original key in both tables and renamed it so that wouldn't be linked.

I then used

>> AutoNumber([keyfield], 'Key') <<

in both the tables.

<=> From the look of it, it seems that quite some keyfields that actually exist in both tables are not linked anymore.

Is there anything I have overlooked?

Thanks a lot!

Best regards,

DataNibbler

Re: AutoNumber() as Key

pokassov — Wed, 01 Apr 2015 09:38:26 GMT

You have to do it in one document during reload

Re: AutoNumber() as Key

datanibbler — Wed, 01 Apr 2015 09:42:06 GMT

Hi Sergej,

what do you mean, in one document?

Re: AutoNumber() as Key

luciancotea — Wed, 01 Apr 2015 09:44:51 GMT

Try Autonumberhash128()

Re: AutoNumber() as Key

pokassov — Wed, 01 Apr 2015 09:49:23 GMT

In one app. If you make key using autonumber for first table in one app and for second table in another. To store data in to qvd file for example and then use both qvd in app, then autonumber will not work correctly.

Re: AutoNumber() as Key

datanibbler — Wed, 01 Apr 2015 09:52:41 GMT

Ah, now I understand.

Well, they are in one app all right.

I'm not quite sure about that as the linking was less than perfect before ...

I'll do a test now, writing down a dozen or so items which are linked using the alphanumeric key, then switch to the numeric and test those same items.

Re: AutoNumber() as Key

datanibbler — Wed, 01 Apr 2015 10:13:08 GMT

Okay.

Thank you all for your help! It does work, after all. It's just that many values cannot be matched - and aren't supposed to. I didn't think about that the first time round. Now I started from the "smaller" side where all items should have a match.

I tested it on a dozen samples and in those cases where the link worked before, it works with AutoNumber(), too. So I'll keep that.

Best regards,

DataNibbler