Dummy customer identity - using functions in Data Distiller

[Michael_Soprano]

How to generate such a dummy identity using Data Distiller? Do you know any function which can create dummy str/int?

[marc_stowe_za]

hi, perhaps create a guid ? In data distiller i think the command is UUID()

[KevinFosterDX]

Opinions differ of course, but I personally would never generate any kind of random identity.

Instead I've always used deterministic methods, such as concatenating other fields from the SELECT row result to construct a unique identity from that.

(This also means being sure to use DISTINCT or similar in the SELECT query to only get unique combinations of values used in that concatenation.)