Generating a BatchID for all the rows

[nsrao_1975]

Hi,

    How can i generate a unique BatchID , a alphanumeric value like '0E984725-C51C-4BF4-9960-E1C80E27ABA0' 

 for all the rows ?  

   I will be loading daily files into the destination. For each run, a BatchID should be assigned to all the records in that run.

So that it helps me to identify the records in the destination for each BatchID seperately.

Thanks,

NSRao

[AdamR_AYX · Accepted solution]

Try the formula function UuidCreate() and then append fields to attach it to every record in your batch

[OmaratRJL]

in UuidCreate() we see () the parenthesis designate some kind of a parameter correct? what are some parameters? Can we for example limit the number of letters maybe we want to not use the letter "o" or the letter "i" how would we do that?