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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema