Percentage of Individuals

[curtisdee13]

Hi,

Does anyone know how to select a percentage of individuals from a selection using Talend components?

My aim is to select 5% of a selection and only insert that into my MDB table.

Thanks

Curtis

[Anonymous]

Hello,

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

Best regards

Sabrina

[curtisdee13]

Hi,

Thanks for replying. My task is to load a random 5% of rows from a database table . So for example if my mySQL table has 1000 rows i'd like to only load 5% of that(50 rows) to my new table.

The issue i currently have is when i try and use mySql to do this it never gives me exactly 5% it's usually in and around so i may get 40 rows or 60 rows. So my question is, is there anyway in talend to help me achieve this?

Hope the above explains my issue.

[Anonymous]

Hi,

    Could you please try the steps mentioned in solution for the queries in below link?

https://stackoverflow.com/questions/5615172/mysql-limit-by-a-percentage-of-the-amount-of-records

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂