Assign a random name

sharon95 · 2016-11-09

I have a table filled with the identification data of thousand of people (name, surname, phone number, address, ...). I have to assign a random name (name + surname) to each of them. How can I do it? thanks!

Kishorm · 2016-11-09

1) Create 2 new tables Firstname & Surname - each table should have 2 fields - ID (Integer = primary key) and Name (text)

2) Loop through your current people table and use this to populate the 2 new tables with first names and surnames

3) Loop through your people table again and for each record use the RANDOM function to generate 2 random numbers and use these 2 random numbers to GET a firstname and surname from the 2 new tables, concatenation the names and replace in your people table

postsaurav · 2016-11-09

Create a new field.
Then create a batch (report / Codeunit) which populate data in new fields based on concatenation of name and surname field.

binilabraham · 2016-11-09

Create a processing only report to do that. Write code inside report to append Name and Surname (Name + Surname) and then modify the record.

Kishorm · 2016-11-09

1) Create 2 new tables Firstname & Surname - each table should have 2 fields - ID (Integer = primary key) and Name (text)

2) Loop through your current people table and use this to populate the 2 new tables with first names and surnames

3) Loop through your people table again and for each record use the RANDOM function to generate 2 random numbers and use these 2 random numbers to GET a firstname and surname from the 2 new tables, concatenation the names and replace in your people table

Assign a random name

Best Answer

Answers

Categories