topic Re: Percentage of Individuals in Talend Studio

Percentage of Individuals

curtisdee13 — Mon, 28 Jan 2019 10:43:22 GMT

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

Re: Percentage of Individuals

Anonymous — Tue, 29 Jan 2019 01:33:46 GMT

Hello,

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

Best regards

Sabrina

Re: Percentage of Individuals

curtisdee13 — Tue, 29 Jan 2019 15:17:34 GMT

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.

Re: Percentage of Individuals

Anonymous — Tue, 29 Jan 2019 17:11:21 GMT

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 🙂