I have a record with lots of rows containing personal information.
Table A

```
ID,FirstName,LastName,Gender,Emai,Phone,Address

```

I am trying to scrub the data using another dataset I created using randomuser.me api.
I have the data stored in another Table B

```
firstname,lastname,gender, phone, processed_flag

```

I want to update all the fields of Table A by getting random data from Table B and once I use that row from table B, I should update processed\_flag as 'Y' so that I do not duplicate the information.

As a result all the data of Table A is scrubbed for security reasons in my non prod databases. Is this possible using Merge statements as I would like to update 10000s of rows. Any help is appreciated. Since there are no keys matching, I am not sure of the approach hence unable to show what I have tried.