Options

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.
[0][0-9][0-9][0][0]

Now I have a ColumnB that I want to use to generate a similarly random ID for the employee.
[A-Z0-9][A-Z0-9][A-Z0-9][A-Z0-9]

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.

Thanks!
Sign In or Register to comment.