dynamically rename by other column

[maxiemens]

Hi guys,

following Problem:

I have the start-situation: 

What I want to do is: rename machine numbers with the same material to the highest one like this:

Does anybody know how I can to that? Maybe with the Formula Tool? 

Thanks in advance 🙂 

[JosephSerpis · Accepted solution]

Hi @maxiemens I mocked up a workflow that produces the output you describe. Let me know what you think?

[maxiemens]

Very smart and easy solution, thank you 🙂 

[ChrisTX · Accepted solution]

I don't think you can use a simple Summarize with a Max, because numbers stored as text won't always get the correct Max value.

If you add these records to your input data, the Max value will be 8

Material	Machine
PG1114	SRV-7000S(8)
PG1114	SRV-7000S(10)

If you add a Text-to-Columns tool then convert the string inside the parenthesis to a number, you'll get the right Max value every time.

 

See attached workflow.

Chris

[JosephSerpis · Accepted solution]

I revised the workflow.