Challenge #22: Identify Values to Aggregate

[pjdit]

My solution.. fun to see the old Icons, but I like the new look more..

Spoiler

[Alekh]

Spoiler

[jagdeep_singh85]

PFA my solution

[dmodest]

I came up with two solutions. In my first solution I used a Text Input tool and fed that into a Find Replace tool.

In my second solution I used a Formula tool and the REGEX_REPLACE String function to replace specific character strings. After that, the remaining tools were the same used in the first solution.

I did not figure out how to change the flow from top to bottom.

Spoiler

SPOILER

[Reesetrain2]

All,

This one took me a bit.

Spoiler

I had to use the Pipe: atm2.(\d{1,7}\.\d{1,7}|\d{1,7}) in the Regex function with Tokenize. It took me a bit to figure out that worked.

Thanks!

Matt

[DanielMS]

Spoiler

[Jonathan-Sherman]

Challenge 22 is done!

Spoiler

[pawan_bagdiya]

Solution attached 🙂

Spoiler

[rslopez2]

Fun throwback and functionality that I had no idea was there.

Solution very inline with others.

-Used pattern as delimiter to split to rows

-Filtered on 'atm2.'

-REGEX to get to number format

Spoiler