AnsweredAssumed Answered

Generating sequence key

Question asked by ranjith.martha569090 on Oct 25, 2017
Latest reply on Oct 26, 2017 by Sjaak Overgaauw

I have the input data as below and at the Database the key column is a Sequence.
Pick the Max value and assign the sequence.

As far i know we can get the max value using SQL lookup or set properties, want to ensure how this works for Sequence..

 

Source fields
CUST_NAME
DOS
ENTRY_DATE


Columns in CUST Table:
CUST_ID - SEQUENCE
CUST_NM
SERVICE_BEG_DT
ENTRY_DT

Outcomes