Excel data mapping


#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.


#5

Thank you @SaranyaKishore