Tile tool - case sensitive

[Javier070590]

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:

Name	Tile_Num	Tile_SequenceNum
AA AAA	1	1
AA AAA	1	2
AA Aaa	2	1

and I would expect:

Name	Tile_Num	Tile_SequenceNum
AA AAA	1	1
AA AAA	1	2
AA Aaa	1	3

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

Marcin

[messi007]

@Javier070590,

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

Apply the Tile

Attached the workflow,

Hope this helps!

Regards,

[Qiu]

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

[Javier070590]

@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