DSXchange

Hi,

I want to get rid of any number of duplicates.

example.

111,111,111,111

should be
111,91110,91111,91112

There can be any number of duplicates.

Please suggest.

Regards,

Is this in one field, i.e. in one string and duplicates are defined by commas?

Hi,

This is in one field and no commas.

it comes in rows.

can you post your requirement clearly?

id
111
111
111
111

required result
id
111
9110
9111
9112

That doesn't really explain much.

Can you spell out your requirements in words? It seems you need to take duplicate values and prefix them with a '9' and then... ???

Do it with stage variables in a Transformer stage. Detect that the value is the same as in the previous row. If so, add prefix and suffix, and increment the stage variable that contains the suffix.