Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

what it does?

Hi all,

what is this use and how it will work can anyone explain?


    AutoNumber(Trim(identifier&code&line&date   &product&manufac&product_id&channel)) as "_KEY";

1 Solution

Accepted Solutions
qlikviewwizard
Master II
Master II

Hi soniasweety

Trim() removes the spaces before and after the value of the filed.

Trim( ' abc' ) Returns 'abc'

Trim( 'abc ' ) Returns 'abc'

Trim( ' abc ' ) Returns 'abc'

Autonumber will give numeric values from 1 to number of values of the field.

We can generate serial numbers by concatenating/joing more than one field. For example as your KEY filed.

Example :

Autonumber(Field1&Field2&Field3) as Key

RegionSales: LOAD *, AutoNumber(Region&Year&Month) as RYMkey; LOAD * INLINE [ Region, Year, Month, Sales North, 2014, May, 245 North, 2014, May, 347 North, 2014, June, 127 South, 2014, June, 645 South, 2013, May, 367 South, 2013, May, 221 ];

The resulting table looks like this:

RegionYearMonthSalesRYMkey
North2014May2451
North2014May3471
North2014June1272
South2014June6453
South2013May3674
South2013May221

View solution in original post

2 Replies
qlikviewwizard
Master II
Master II

Hi soniasweety

Trim() removes the spaces before and after the value of the filed.

Trim( ' abc' ) Returns 'abc'

Trim( 'abc ' ) Returns 'abc'

Trim( ' abc ' ) Returns 'abc'

Autonumber will give numeric values from 1 to number of values of the field.

We can generate serial numbers by concatenating/joing more than one field. For example as your KEY filed.

Example :

Autonumber(Field1&Field2&Field3) as Key

RegionSales: LOAD *, AutoNumber(Region&Year&Month) as RYMkey; LOAD * INLINE [ Region, Year, Month, Sales North, 2014, May, 245 North, 2014, May, 347 North, 2014, June, 127 South, 2014, June, 645 South, 2013, May, 367 South, 2013, May, 221 ];

The resulting table looks like this:

RegionYearMonthSalesRYMkey
North2014May2451
North2014May3471
North2014June1272
South2014June6453
South2013May3674
South2013May221
sibin_jacob
Creator III
Creator III

In simple words

It is creating a unique key by combining multiple columns.

It may be because, there no column value is unique.

then using this key to join with other tables.

It is better to have join key as numeric to improve the performance, so it is using Autonumber function to create the numeric value for combined column values.

Trim function to trim the values (remove the space).