Hi
i need to keep my rows as follow but after doing the calculation and mapping i am getting that current view (second table)
expecting -
Current View-
OP
Thank you
kauser
@kauser - Add in record ID before you transform the data, then re-sort on record ID after your calculations and mappings.
@kauser how were these sorted if you have sorted them in your workflow, you can add a sort tool again after the transformation.Else you can add a reference column in starting which can be used to sort your final data.hope this helps.please let us know if that does not work.
