Hi All,
i am a beginner of UiPath user and im trying to build my first robot for reminder of expiry date and RFQ robot.
Which i started with the data capturing by using excel application scope, im able to read the data, somehow i get stuck by the row data whereby it read empty data on the second attempt, following by fourth and sixth attempt with empty info.
How do i skip this without prompting empty data shown?
Hey!
Use filter data table…
Provide the following f=details:
take for each row
Do the same which you’ve mentioned above
Regards,
NaNi
Hi Nani,
Thank you so much for your promptly replied and the solution given.
Somehow i have tried to adjust the excel data table in order to read correctly.
Could i ask how do i filter a date that is going to expired says in 2 months in advance?
i know there is a command for .AddMonths(2) somehow we need to let robot to know that certain items that are going to expired in coming 2-3 months times with reminder.
And also certain items which no longer need to filter.
Main.xaml (10.2 KB)
Hi!
Those items should be removed or need to fetch those details?
Reards,
NaNi
Hi!
yes those details need to be fetch and send reminder of which item are going to be expired says in 2-3 months. so that i am aware and without miss out the item something like that
i could write the data without issue, but somehow i do not know how to get and set reminder.
Regards,
Fred
Hey!
So use filter DataTable to get the items which is near to expiry…
Example:
ColumnName=Now.AddMonths(2)
Regards,
NaNi
Hi Nani,
Good day.
i have tried to filter the row says 2 months in advance to expiry, but seems like it still filter out all date items.
How do i be able to only filter those items 2 months in advance that are going to expired?
And also to write the data out. For example, i managed to get the data i want, but still i couldnt filter only the items that are going to expired in 2 months.
Hope you could help and advise.
Thanks.
