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

[MarmottePluton]

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.

[atcodedog05]

Hi @MarmottePluton 

Multi-row formula would be something like this.

Hope this helps : )

[MarmottePluton]

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!

[atcodedog05]

Hi @MarmottePluton 

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

[RolandSchubert]

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