topic Re: Random number genaration in Talend Studio

Random number genaration

Anonymous — Sat, 16 Nov 2024 13:10:26 GMT

Hi,
I am new to Talend, I am working on open studio tool, I would like to generate a number with in the numbers.
The number are starting from 0000 to 9999, with in the number find out the not in sequence number and generate the new number, it is in DB2. Please help me out.
Thank you,
Praveen

Re: Random number genaration

Anonymous — Thu, 23 Dec 2010 05:45:23 GMT

Hi
for this you can use random number generator in java
java.util.Random (package)
// for generating random number for the range b\w 0000 to 9999
int randomInt = randomGenerator.nextInt(9999)

Re: Random number genaration

Anonymous — Thu, 23 Dec 2010 14:03:19 GMT

Thank you - Lijo,
And I have one more question about on the same scenario, I would like to check the available numbers ( 0000 to 9999 ), If not available number in between ( 0000 to 9999 ) generate the new number. Could you please help me out?
Thank you,
Praveen

Re: Random number genaration

Anonymous — Fri, 24 Dec 2010 06:41:07 GMT

Hi Praveen
Are you storing to numbers in the database?, if yes you can put a query else
you can save the numbers to an arraylist and then check if it contains
boolean blnFound = arrayList.contains("2")
Hope it helps you