Empty Data capturing

[Alfred_Gan (Fred)]

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?

[THIRU_NANI (NaNi)]

Hey!

Use filter data table…

Provide the following f=details:

1. Input Dt as-> Read range output
2. Filter wizard-> Remove->ColumnName in quotation marks->Select->IsEmpty
3. Save to Different Dt

take for each row
Do the same which you’ve mentioned above

Regards,
NaNi

[Alfred_Gan (Fred)]

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)

[THIRU_NANI (NaNi)]

Hi!

Those items should be removed or need to fetch those details?

Reards,
NaNi

[Alfred_Gan (Fred)]

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

[THIRU_NANI (NaNi)]

Hey!

So use filter DataTable to get the items which is near to expiry…

Example:

ColumnName=Now.AddMonths(2)

Regards,
NaNi

[Alfred_Gan (Fred)]

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.

[Alfred_Gan (Fred)]

Good day.

Just to follow up as i had try to do this filter but somehow i could not get any data which is empty.

Filter row

Output Columns

result in write range table

your advise is highly appreciated.

Sincerely,
Fred