Tile tool - case sensitive

Question

Hello Alteryx Community,

Is it any way to make a tile tool NOT case sensitive?

I have a data with duplicated names, however I cannot delete duplicates.  I thought that I will add suffix "_" to the name if there is (one or more) duplicates. I use Tile tool first and then formula tool to add suffix, the problem is that Tile works like:

NameTile_NumTile_SequenceNumAA AAA11AA AAA12AA Aaa21

and I would expect:

NameTile_NumTile_SequenceNumAA AAA11AA AAA12AA Aaa13

Is it a better way to receive output from the second table?
Thank you in advance,

Marcin

Javier070590 · Answer

@Qiu @messi007

Thank you for your replies. I thought about the change, but the only change I could do is capital letter in every word:

Aaa Aaaaaa Aa Aa

If i am not wrong I can to it only for the first word. The problem is that I can't change anything as capital letters as management says it looks bad in the dashboard, in my examples there are some expressions with all capital letters however they are hidden, in the final dashboard there is only AA Aaa visible. However while loading into dashboard, systems treats them as duplicates.

Cheers,

Marcin

Qiu · Answer

@Javier070590 
In case you want keep the original field unchanged.

New Workflow2.yxmd

messi007 · Answer

@Javier070590,

What about using Upper case with data cleansing tool, apply the tile.

Apply the Tile

Attached the workflow,

Hope this helps!

Regards,

Tile_20210315.yxmd