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!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend