Hi, I build a process to scrap data from ecommerce site and store it in excel file then i use excel application scope to read data and add a column “Interested” then i want to filter that data and in filter datatable activity i use condition that Price > 16000 and i want to store “Yes” in Interested column. Any one help me that what is good way to do this?
A similar question has been asked earlier today in the forums.
You could check this link for alternative ways to solve your issue. The link is related to null values but it is quite similar logic. In your case you have to modify the condition to a greater than or lower than type and provide a reference value to compare to.
If you don’t mind can you help me?
here is my excel file in which i want if price is greater than 16000 then in interested column “Yes” value stored if not then “No” value store
Read excel but remember to Uncheck Preserve Format. This way the Currency format will not be imported and only number will be imported to UiPath. Store that in a InputDatatable
Build a datatable with the required Columns
Use a For Each Row in InputDatatable and use a IF condition.
FilterTableWithoutPreserveFormating.zip (6.8 KB)
Alternatively since you will Uncheck the Preserve Format while reading the excel file, your filter screenshot will also work. That way you do not need to have interested column. It is your choice
Hope this helps!
If: Conversion from string “Rs 93,500” to type ‘Integer’ is not valid. This error occurs
Did you uncheck PreserveFormat when reading the excel file?
If you did that already, then you can try this.
It will remove the “Rs” and “,” and only leave 93500 for example which can then be converted to Cint.
Ok may be i was wrong on the syntax for multiple replace. You can try this.
Thanks It work. but not write in excel file Interested column, it write in output panel
Just use a write range activity and use the output datatable. You will get a new excel file with Interested columns filled out.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.