Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Key Concatenation best use

Hi all,

I'm looking for your advice in the aim the get a optimized script.

sometimes, i've to do a concatenation of different keys, it can takes 9 keys by the way.

in this way, what function you advice me to use Autonumber() ? autohash128() ? autohash256() ?

and what about concat()

regards

1 Reply
Not applicable
Author

Hello Nassim,

Could you see this post which talk about Autonumber and AutonumberHash :

http://community.qlik.com/message/289359#289359

You can use Concat() in order to get all the possible values in a field. For example, you can have a field TEST which contains this values :

- A

- B

- C

- D

If you do this :

concat(TEST, ';')

The result will be :

A;B;C;D

You can read the Help (F1) in order to have more explanations.

Amand Dupretz