topic how can generate random phone numbers or 10- 12 digit interger in Talend Studio

how can generate random phone numbers or 10- 12 digit interger

Anonymous — Thu, 26 Jul 2018 16:50:51 GMT

hello

Is there any way to generate random phone number or 10-12 digits integer values.

i tried to generate through tRowGenerator but it can't work..

Re: how can generate random phone numbers or 10- 12 digit interger

aashish_21nov — Thu, 26 Jul 2018 17:43:27 GMT

as we know there is upper and lower bound limitation of integer type so we can't directly generate 10-12 digit

so what i did is:

job look likeusing random value function we define 9 digit max and min valueand in tjava converting integer to string and concating 10 value as "9" in them

Re: how can generate random phone numbers or 10- 12 digit interger

Anonymous — Fri, 28 Sep 2018 14:02:34 GMT

Hi,

I am getting data conversion error, as newColumn is Integer.

Re: how can generate random phone numbers or 10- 12 digit interger

aashish_21nov — Fri, 28 Sep 2018 14:22:57 GMT

Make Integer to String