What are the challenges you face when working across database platforms? Take the survey

How to write a python script to pair two values between columns together?

CoryWCoryW Posts: 1 New member
edited August 16, 2018 9:04PM in SQL Data Generator
I have ColumnA that uses a regular expression to generate non-unique employee IDs.

Now I have a ColumnB that I want to use to generate a similarly random ID for the employee.

And I want to ensure they always pair up. So if ColumnA = 02200, and ColumnB = AA98, then the subsequent occurrences of ColumnA = 02200, ColumnB should equal AA98.

Perhaps there is a Python Script that accomplishes this? I'm not quite sure where to go from here.

Sign In or Register to comment.