Hi Team,
I have one doubt, Attaching the excel in which expected output and Input and also Order is mentioned. It would be great if i find the solution for this asap.
Thanks,
Ayesha
Please also provide the basic logic you want to follow. The expected output isn't self-explanatory.
Should the input records by grouped and/or sorted? By Company Number or Company Name or both? Then join to the Sort Order. Then how is the Common Node determined?
I want to replace the Node column data with the first order of value in the order column. Company number and Company name remains same only the last column will get change
I interpret that you want to append a field, which is the highest order(priority) among nodes that each company has.
With this understanding, I prepared WF, please see attached. At least output is match to yours.