Summarize Tool

Question

Hello,

I've got some data that is in multiple rows and I need to join them to one cell based on the work order number. I'm using the summarize tool, however, it's not working for some of my work orders. I believe it's because they have aphabetical characters mixed with numerical characters. Below is an example.

Data before the tool:

Work Order 123456 John Right

Work Order ABC123456 Happy Small

Work Order 123456 Ashley Right

Work Order ABC123456 Aspen Small

How I want it:

Work Order 123456 John Right Ashley Right (This works fine currently)

Work Order ABC123456 Happy Small Aspen Small (Isn't working)

Maskell_Rascal · Answer

Hi @Cwynot

If Work Order is always in the column, I think this workflow will do it for you.

We can first strip out "Work Order", then use a RegEx Parse, eliminate any spaces from the data, summarize/concatenate together, and then combine it all back again.

See attached workflow.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Summarzie with RegEx Parsing.yxmd

atcodedog05 · Answer

Hi @Cwynot

Is my workflow close by?

I think your input might look like the table after text to column.

Can you provide snapshot of how your data looks.

Cwynot · Answer

No, the work order number is one column and the name is in a different column. I also tried the len formula and that didn't work either.