How to map data in excel from another sheet?

I want to map data from sheet2 to sheet1 and write data in column H-K in sheet as below.
(map by column CAT No.)

data.xlsx (10.3 KB)

Please guide me about it.


Can you please refer attachment?
you need to extract time from datatime col and write it in Time col.
this is not perfect and u will need to modify based on requirement.

_Test.xaml (15.0 KB)

@Pankaj.Patil error if activity as below.


Please try to solve them, i did not run the workflow and just made it.
i can not assign much time to community today, little busy.

Thanks for understanding…

1 Like