dynamically rename by other column

Question

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 🙂

WF_20082020.yxmd

JosephSerpis · Accepted Answer

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

ChrisTX · Accepted Answer

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

MaterialMachinePG1114SRV-7000S(8)PG1114SRV-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 Answer

I revised the workflow.