Lesson 9 - Filter Wizard not filtering data table as expected

Learning Hub Academy Feedback
21

Hi @nealross

Would be great if you have some samples? We will need to filter/sort/mainpulate lots of excel files throughout our automations so would be good to have an easier way to achieve it.

Thanks

22

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

24

Late reply but I have just joined the RPA community.
This may help for any future user encountering the issue.
This problem has been resolved in Modern Design Experience.
You can change the data format using Extract Data Table wizard available in Modern design Experience. So filtering on integers is direct and no more workarounds needed.
Hope this helps.

1 Like
25

Would you provide examples please?

26

In modern design you have the activity - Extract Table Data.
If you click on the property for this activity You have in “INput” a property called Table Settings, which takes XML as input.
So in that u can change the type .
Eg - Converting INvoice Number to Number instead of Text

=====================
Attaching a sample xaml file for the same -
WFLoadAcmeData.xaml (37.2 KB)

hope it helps