Summarize Tool

[Cwynot]

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)

[atcodedog05]

Hi @Cwynot 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AngelosPachis]

Hi @Cwynot ,

Probably the fields are slightly different between them that's why you can't group on them as you were hoping for. Can you validate that the fields have the same length by sticking a formula tool and using the LEN(field_name) function.

"ABC123456" and "ABC 123456" may look the same, but there is an extra whitespace that you might not be able to see with naked eye.

Thanks,

Angelos

[Cwynot]

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. 

[atcodedog05]

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.

[Maskell_Rascal]

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