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.
George and John
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.