Find uniques based on parts of date field and parts of a string field

[chvizda]

Hi Community

I have a dataset with incidents for Network Links.

It contains the Router Names and the Ticket created time. The network link can have 1 to 3 routers. If all of the routers are down at the same time I need to mark it as Full outage:

Example:

Router Name                                        Ticket                       Create Date

any-lani-prod-us-nyc-c-003003	REF000047668783	18.08.2017 12:46
any-lani-prod-us-nyc-c-004004	REF000047668932	18.08.2017 12:55

The name is unique up to the numbers (Italic)

The date is unique up to the hour. (italic)

Is there any formula available to create a new field based on these data ?

Many thanks in advance

Steffen

[ddiesel · Accepted solution]

Hi @chvizda 

I'm sure there might be a more sophisticated approach but let me know if the attached workflow will work for you.

[chvizda]

Hi @ddiesel

Thx, you pointed me to the right way.

Steffen