Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DirtyHands
Contributor
Contributor
‎2021-08-11 02:59 AM

Serial number as id=id+1

I have output table for accepted values as well as file from tmap.

I want to add serial number column for the outputs. However, I don't want the serial number to start from 1 every time. I want it to start from the last serial number.

Eg if the max serial number is 100 then I want the serial number to start from 101 in the next run.

I tried using context variable and tjavarow but I am not able to get the desired output.

Please suggest me how to do this for both database output and file output delimited.

Labels (4)
63 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2021-08-12 11:22 PM

Hi

We usually store the max serial number to somewhere such as file or DB, load this value from file or DB in the beginning of job and store it to context variable for used in sequence function.

 

Regards

Shong

63 Views
0 Likes