Filter data table error

Help
,
1

Hi,

Occasion: Based on the former result(please refer to this link: How to identify Checkbox and its value in word and write to excel - #16 by Celinnie), I would like to keep rows that CheckBoxStatus=True and save the results as a new datatable. But I received this error by using assign:
WeChat%20Screenshot_20191024145031

Assign:

WeChat Screenshot_20191024145432.png
WeChat Screenshot_20191024145432.png821×518 25.2 KB

Workflow:
read range->clear data table->assign->append range
WeChat%20Screenshot_20191024145511

Thank you so much!

2 Likes
2

Hi @

Please chnage the check box statu variable type to boolean

Regards
Ajay

3

Hi @Celinnie

You can use filter table if you are not sure about your sintax :smiley:

cheers :smiley:

Happy learning :smiley:

3 Likes
4

Actually, I tried filter datatable, and didn’t return any result, workflow like this:

1
1618×569 12.5 KB
2
2659×508 11.7 KB

And the settings for filter datatable is here:

3
3747×476 13.2 KB

Thanks！

1 Like
5

did you check your input table if it has some value on it before make some query on it. @Celinnie

cheers :smiley:

Happy learning :smiley:

3 Likes
6

Yes, I have tested the input table has the value.

1 Like
7

Great @Celinnie

Then try to filter any column not the boolean part. for us to see whats the problem!

cheers :smiley:

Happy learning :smiley:

3 Likes
8

Yes， I tried filter Name Column, 4

The input datatable:

5
5608×808 12.4 KB

The output datatable(I added headers manually)
6
6301×806 5.78 KB

The output:
7

1 Like
9

You were almost done
Unless the column in the datatable that holds true or false is not a Boolean then it must be a string
So along the select statement mention the True as a string like this
Yourdatatablename = Yourdatatablename.Select(“[columnname] = ‘True’ “).CopyToDatatable()

Cheers @Celinnie

10

@Celinnie Yey were almost there

3 Likes
11

@Celinnie
Can i have your excel file i will try to read it. :smiley:

cheers :smiley:

Happy learning :smiley:

4 Likes
12

I edited however, I still receive the same error.

1
1715×261 7.38 KB

I also tried to assign CheckBoxStatus variable to string, however it didn’t work.

13

Thank you for your help, here is the excel file, I would like to keep rows that CheckBoxStatus = True.
example.xlsx (10.5 KB)

1 Like
14

Hi @Celinnie

Yes this is noted later I’ll check the sample excel and give some feedback to you once done.
Thanks. :smiley:

cheers :smiley:

Happy learning :smiley:

3 Likes
15

Hi @Celinnie
I tried your excel and create some sequence of activities and i think i got it right.

image
image706×459 17.7 KB

cheers :smiley:

Happy learning :smiley:

3 Likes
16

Hi pattyricarte,
unfortunately, I still get this error. can you show me the formula in assign and is there any operation you do in your excel?

2 Likes
17

@Celinnie
Later i will

cheers

3 Likes
18

I just tried to define a new data table, and it worked!

thanks for your kind help!

2 Likes
19

Wow your great @Celinnie

No worries happy to help here.

by the way here is the assign formula just you want to have a reference.

dtOutput.Select(“[CheckBoxStatus]=‘True’”).CopyToDataTable

cheers :smiley:

Happy learning :smiley:

3 Likes
20

Hi pattyricarte,

Another quick question is that if I would like to identify several word file with checkbox, is there a way that don’t need to open each word file to finish this task?

Since now, I use get attribute activity to identify checkbox in a word file, but if I have several word files, I need to open each word to indicate on screen , it’s time-consuming.

Do you have good solutions?

2 Likes