topic Re: Creating a Key with Table Fields in QlikView

Creating a Key with Table Fields

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

Hi All - we are trying to create a 'key' to use to match two separate tables. The fields we are using have been imported from an SQL source and renamed prior to creating our key. We have tried using both the field name that came from the table, and the renamed fields, but are getting error messages on both.

What is the preferred way to create this key? The key is a string, a date and a number. Please see the script attached. Any suggestions would be welcome.

Thanks!

George and John

Re: Creating a Key with Table Fields

sunny_talwar — Mon, 23 Jul 2018 19:30:15 GMT

Instead of +, may be you need &

Re: Creating a Key with Table Fields

sunny_talwar — Mon, 23 Jul 2018 19:30:56 GMT

Actually you are doing this in SQL... which database are you pulling the data from?

Re: Creating a Key with Table Fields

gfisch13 — Mon, 23 Jul 2018 19:57:17 GMT

Pulling the data from an SQL table. The script is within QV.

Re: Creating a Key with Table Fields

maxgro — Mon, 23 Jul 2018 21:26:36 GMT

try with field names instead of the alias

"EMPE_ID" + "TRAN_DT" + "TRAN_AMT" as "KEY"

Re: Creating a Key with Table Fields

agarwalrits13 — Tue, 24 Jul 2018 00:51:14 GMT

If the script is in qlikview then you can also use autonumber in order to join the Keys.

AutoNumber (EMPE_ID,TRAN_DT,TRAN_AMT") as Key .

Re: Creating a Key with Table Fields

qlikviewwizard — Tue, 24 Jul 2018 02:13:12 GMT

Hi gfisch13,

Can you attach some sample data with 10 rows.

Re: Creating a Key with Table Fields

agarwalrits13 — Tue, 24 Jul 2018 18:45:13 GMT

If the script is in qlikview then you can also use autonumber in order to join the Keys.

AutoNumberhash128 (EMPE_ID,TRAN_DT,TRAN_AMT) as Key or AutoNumberhash256(EMPE_ID,TRAN_DT,TRAN_AMT) as Key

AutonumberHash process 30% faster than normal autonumber.