Hoping someone can help...
I've got upto 12 fields with string values that I want to join together into a single string. I can use concatenate or join to do this however some of the fields have duplicate values. Is there a way to remove duplicates from the joined string? example of inputs might be:
Which I would want to make into a single string of:
'P_12567 P_12568 P_12569' - so the duplicated P_12567 is ignored
Many thanks in advance :)