Excel data mapping

Help
1

Hi All,

I have one excel sheet with column Date , Month and Year.
I need to separate month and year from date and put them into month and year Column.MonthYear.xlsx (8.1 KB)

please help…

Regards,
Sagar.

2

Hi @SagarSB,

Split string activity can be used.
Take the separator as “/”.
image

3

can you please provide solution by using my excel file.
it will be great help.

Regards,
Sagar.

4

Here is the solution.
Getting_Month Year.xaml (8.6 KB)

After this you can use “write cell” activity to write in the excel.

2 Likes
5

Thank you @SaranyaKishore