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
What about using Upper case with data cleansing tool, apply the tile.
Apply the Tile
Attached the workflow,
Hope this helps!
Regards,
@Javier070590
In case you want keep the original field unchanged.
@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