topic Re: How to trim last two dgits in Alteryx Designer Desktop Discussions

How to trim last two dgits

Saravanan13 — Fri, 03 May 2024 08:55:41 GMT

Hello,

I am looking to trim the last digits of "ID" column, Can anyone assist on this

ID	Expected output
5555525	55555
1701235	17012
1701245	17012
2801299	28012
2801249	28012
5555535	55555

Re: How to trim last two dgits

ShankerV — Fri, 03 May 2024 09:05:26 GMT

Hi @Saravanan13

There are many ways to achieve this output.

In the formula tool, use the below

Left(tostring([ID]),5)

Note: Assumption made that the ID column length is 7

Re: How to trim last two dgits

aatalai — Fri, 03 May 2024 09:42:42 GMT

Agreed with @ShankerV there are many ways. I've attached a workflow that is slightly more dynamic, i.e will work if the column length is not 7. Let me know how you get on