Hi!
I have a list containing incoming arrivals (persons) to a country. I would like to identify which people are traveling together. I have over 20 variables for this, but just to get an idea of how to do this, i am using the 7 most important variables.
Attached you find an anonimized sample to give an impression.
I would like to give unique string of 12 characters to identify people who travel together.
For this i would like to use:
timein - the time they pass customs
datein - the date they pass customs
last name
place of stay
country of residence
edcardnumer
length of stay
If you don't have the answer, can anyone tell me how to generate a random string of 12 characters (numbers + letters)?
Thanks in advance.
What is your underlying database?
If you're looking at SQL Server, something like this should work:
https://stackoverflow.com/questions/1324063/generating-random-strings-with-t-sql