TRIMMING AND RETAINING DIGITS

how to make this consistent with only 8 digits? tried everything from trim to substring to padleft and right. really need it asap it will make duplicates everytime i trim and retain.

11105202
11106000
11106002
12150001
41412003
41412005
41412006
41412803
5151550000
5151550001
5151550002
5151551500
5151552000
5151552002
5151552007
5160600000
5160600001
71830000
71850000

Transformation

Accepted answers

All comments

JUST LIKE THIS....

6151551303 Janitorial & Cleaning Supplies/Materials 1385781.72 51551303

6851551303 Material Issues - Consumable 126588.98 51551303

the bold numbers are generated from doing padleft and subtring that causes duplicates.

I hope I understood your requirement correctly.

Please find the solution below.

Many thanks

Shanker V

hi. i did that before. however, it'll create duplicates.

Step 1: Input

Step 2: As the data's are in numbers Alteryx will directly consider as Double

Use Select tool to convert to String

Step 3: Use Regex tool to get your output

Let me know if there's anything above I can clarify for you further.

From the output column, I have shared. Use the Unique tool to remove the duplicates.

That will resolve the issue.

Hope your issue is resolved.

If not let me know how your expected output should be, so can work on it.

Shanker V

yes2 but they have different amounts. so i could not retain unique codes only

Sorry your output expectation is not clear,

Can you explain it clearly. What is your expected output.

Shanker V

i should remove those in red to create an 8 digit account number same with other accounts. however, the first 2 digits were removed

Please find the solution below. Is the output is what you are expecting right?

Shanker V

hi. yes2. i'd like to try that solution.

Solution is in Regex tool, just change the highlighted as in yellow.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

hi. thank you. it worked for some. however, i still got the same results, still have duplicates just like these. im really having a hard time.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703