Assign Unique Value based on Row Value and assign next number when Row value changes

Question

Hi,

I have a workflow with 2 inputs -  A 1st input containing  a Vendor ID and Amount and a 2nd input containing an ID number.

I am looking to assign the first value in the 2nd input to the first value in the Vendor ID column (12345) and keep it going until the Vendor ID changes to the next number (456446), ect. So that Vendor ID 12345 would be associated with ID "1", then 456446 would be associated with ID "2", ect..

I have tried using the multi-row formula tool but I can't seem to fathom how to create some kind of a join or union between my 2 inputs. Any help??

Worfklow sample is attached.

Workflow Sample.yxmd

RolandSchubert · Answer

Hi @MarmottePluton ,

you need one one additional step. @atcodedog05  provided a solution to add an "Id" to your first input, you have to add an Id to the second input as well and use a join to get the result you need.

Could look like that:

Best,

Roland

Workflow Sample 2.yxmd

atcodedog05 · Answer

Hi @MarmottePluton

Its not clear can you provide the expected output. I will be happy to help 🙂.

MarmottePluton · Answer

Thanks for the reply! However, the workflow you have below doesn't seem to reference the 2 input which contains de ID. The workflow would need to assume that the values in the 2nd input could change.

Hope this makes sense!