topic Re: Working with Autonumber function in QlikView

Working with Autonumber function

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

In my Qlikview Application we have data for returns and we are using Autonumber() to generate keys, we have a huge data and created number of keys.
In addition we have Text data for some fields with two languages, here also i have used Autonumber() to generate keys.

Now i have requirement where i have to join the main table with these Text tables.

Example:

FinalTable:

Filed1,

Field 2,

Abc_key_field,

Def_key_field,

........

resident table;

Text_MaterialnumTable:

Abc_key_field,

Text_Materialnum;

Resident Table:

Text_OrderNumTable:

Def_key_field,

Text_OrderNum

resident Table;

Like we have nearly 15 tables to join. Now the problem is if we join these many table to the FinalTable we are facing some performance issues, the reload time is increased and some times the task in QMC is getting failed after loading for hours.

Please Suggest the best way.

Re: Working with Autonumber function

ramcena306 — Tue, 08 Oct 2019 11:45:12 GMT

Hello Friends,

Any ideas on this ?

Re: Working with Autonumber function

sunny_talwar — Tue, 08 Oct 2019 12:03:05 GMT

Have you checked the log files? Where exactly is it failing? If it failing to Join or is to failing when you create the AutoNumber key?

Re: Working with Autonumber function

ramcena306 — Tue, 08 Oct 2019 13:33:43 GMT

Hi Sunny,

In log file i can see the error "Execution cancelled by user" but nobody cancalled the task, It is failing at the time of joining tables with FinalTable.

Re: Working with Autonumber function

sunny_talwar — Tue, 08 Oct 2019 14:29:58 GMT

So, the join can fail because of lack of resources to join which could be because of

1) Joining a big table

2) Many to many join

Re: Working with Autonumber function

ramcena306 — Tue, 08 Oct 2019 14:49:02 GMT

Hi Sunny, So, is there any other way to join, or any other approach that you can suggest.

Re: Working with Autonumber function

Brett_Bleess — Mon, 14 Oct 2019 15:11:05 GMT

Ramesh, have a look at the following Design Blog post, may be what you need in this case:

https://community.qlik.com/t5/Qlik-Design-Blog/Autonumber-function/ba-p/1464970

Regards,
Brett