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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Generate 20 digit random SimCardNumber(int) in Talend Open Studio

Hi,

How to generate 20 digit random SimCardNumber(int) in Talend  Open Studio?

 

Thanks,

Dhara

Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hello,

This component tRowGenerator can create an input flow in a Job for testing purposes, in particular for boundary test sets.

Please refer to this online component reference:https://help.talend.com/reader/BM9JUGjCyUoc77mebzVshw/TifKX_CgJCoB3aoxG3QqGQ

Best regards

Sabrina

Anonymous
Not applicable
Author

Hello @dhara3010

Is this component Ok with you?

Feel free to post your issue here.

Best regards

Sabrina

Anonymous
Not applicable
Author

Hi,

I used this component but didn't got the expected result as I needed. I used explicitly appended a number 9 to make it 10 digit number.

 

Thanks,

Dhara

Anonymous
Not applicable
Author

Hello,

Could you please elaborate your case with an example with expected output values?

Best regards

Sabrina

Anonymous
Not applicable
Author

Hi,

 

     The maximum value of integer data type in java is 2,147,483,647. So you cannot directly create the sim number as integer type. But I have generated the random 20 digit sim number in string data type.

0683p000009M0Ro.png

 

 

For this, in the sequence, I have created four columns of integer data type with values ranging from 10000 to 99999. In the tmap, I converted them to string and concatenated the values. Hope it will help to resolve your query. The component screen shots are as below.

0683p000009M0HR.png

 0683p000009M0Rt.png

 

 

 

The expression used is as below.

 

Integer.toString(row1.sim_number_part1)+Integer.toString(row1.sim_number_part2) + Integer.toString(row1.sim_number_part3) +
Integer.toString(row1.sim_number_part4)

 

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome.

 

Warm Regards,

 

Nikhil Thampi