Copy field of string to get for manipulation

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

Datasets

Data Investigation

Accepted answers

JosephSerpis

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

All comments

JosephSerpis

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

Duplicate_03072020.yxmd

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 ?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703