Hi SR ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query here.
As per my understanding you are trying to generate a unique Guid that contains only numeric characters and is of length 20 for every row in a table. Please let me know if that is not the requirement here.
uuid() function in mapping dataflow can help to generate guid , but again it would give alphanumeric characters .
To achieve numeric GUID, you can use 'random' function in mapping dataflow it will generate random numeric with partition as seed upto 16 characters , however, concatenating with another random numeric would make it upto 20 characters using substring. Try the below expression in derived column transformation:
substring(concat(ltrim(toString(random(1)),'0.'),ltrim(toString(random(1)),'0.')),1,20)
Alternatively, you can use rand() function in ADF pipeline or in SQL itself to achieve the same.
Hope it helps. Kindly accept the answer by clicking on Accept answer
button. Thankyou