Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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..

Labels (2)
3 Replies
aashish_21nov
Creator
Creator

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:

 

0683p000009Lytl.pngjob look like0683p000009Lyml.pngusing random value function we define 9 digit max and min value0683p000009Lywt.pngand in tjava converting integer to string and concating 10 value as "9" in them

Anonymous
Not applicable
Author

Hi,

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

aashish_21nov
Creator
Creator

Make Integer to String