I need to generate Numeric seq. ( integer ) without using Numeric.Sequence() function.
for Example :
input Data : only 1 column (string ) "name" , has 5 values , A,B,C,D,E
Output : id(int) Name(string)
I need to use variable , expression using tMap (or other suitable components).
May I know the reason why internal numeric sequence is a problem for you?
If it is a scenario where you would like to start from last loaded sequence number (like in a DB), you can pick that value first from DB and load to a context variable. Then you can start the sequence from the loaded value instead of 1.
the scenario demands to avoid the inbuilt function , can you please give me the solution using variables in expression builder ?
Thanks in advance .
Could you please me more context why the sequence function cannot be used for your use case scenario?
If you could explain your specific scenario in detail, we can provide a better solution. All normal scenarios can be handled by above function including the sequence number generation from a specific number instead of 1.
I am really interested in a scenario where this function should not be used.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.