Main.xaml (9.7 KB)
Cheers @SAHIL_PANDITA
and one more request, I want these two changes in another column. i.e h and i.
I donβt want to change these two rows in the same field.
If possible please, please suggest
you want to Shift Employee Column to Another Column and change ??
Yes, right
okay,iβll try attaching workflow soon
May I know the issue you were facing with this
Cheers @SAHIL_PANDITA
Hii Palaniyappan,
Your workflow completes my requirement.
Many many thanks.
Cheers @SAHIL_PANDITA
Hii Padeep,
Palaniyappan workflow fulfilled my requirement.
Thank you for your always prompt reply.
Can you please explain the below two lines:
-
βFβ+(dt.Rows.IndexOf(row)+2).ToString
-
IF(row(1).ToString.Contains(βYesβ),β1β,β0β).ToString
This is to mention the cell range in WRITE CELL activity for F column where dt.Rows.IndexOf(row) gives the row index of current row in iteration of FOR EACH ROW activity and we add plus 2 to match with excel row
Usually row index in datatable starts from 0 but we need to start writing from 2nd row in excel
So adding plus 2
And for this
This is a short way to use IF condition where if this conditions satisfies
It will give us Yes
Or gives us No
Cheers @SAHIL_PANDITA
Cheers @SAHIL_PANDITA
Got it
thanks
Have a Great day @SAHIL_PANDITA