Copy field of string to get for manipulation

[Borisham]

Hello

I would like to create a duplicate a string field that allows me to manipulate / change and after I will not select it

This is the case

I would like like to create a duplicate field of store_id to select the max number. The new field just will be used for manipulation and does not show the in the output.

Order_id	store_id(String)
112	VY021
112	D0143

Thanks

[JosephSerpis]

Hi @Borisham I mocked up a workflow that shows how to duplicate the field. Let me know what you think?

[Borisham]

@JosephSerpis That's great! thanks!!

After I create a new field and order by descending order I would like to select just the only one row, the first row for the output.

How can I do it please ?

[JosephSerpis · Accepted solution]

Hi @Borisham you can use a Sample Tool or  Select Record Tool to select only one row. 

[Borisham]

@JosephSerpis Thanks, it's really helpful