Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Original value display after Autonumber()

Hi Experts,

I have a key column which has a string values. I converted it to numeric key column using the Autonumber() function.

However, when I try to display the original column values, I could not get it displayed.

Please check the sample document attached.

I was able to display the original values of the column only after RESIDENT Loading but not normal load from QVD.

Isn't there a better of doing it?

How to display the original values of the column that is used in Autonumber function?

Any help here is highly appreicated.

Regards,

Shyam.

10 Replies
MayilVahanan

Hi

Character fields comes as it is like database..

If you need to convert to string, you can use Text() function

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.