Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

with out date and primary keys how to do incremental logic

If data has no date key and primary key how to do incremental logic.

5 Replies
sunny_talwar

How does your data look like?

ogautier62
Specialist II
Specialist II

Hi,

you ought to have necessarily a functionnal key to calculate increment,

ie what are the fields which identify your row as could do a primary key ?

regards

Anonymous
Not applicable
Author

Here data is like historical data we didn't have primary key

I think hash128() will works but i need exact logic and simple logic

ogautier62
Specialist II
Specialist II

ok,

use Autonumber('with fields you want')

ex :Autonumber(IdProduct & CustomerID & ......)

Anonymous
Not applicable
Author

Hi Gautier

Thanks for reply i tried but using peek with hash128() i got the result.

Thank you