Filter data table error

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), 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

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

Thank you so much!

2 Likes

Hi @

Please chnage the check box statu variable type to boolean

Regards
Ajay

Hi @Celinnie

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

cheers :smiley:

Happy learning :smiley:

3 Likes

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

And the settings for filter datatable is here:

Thanks!

1 Like

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

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

1 Like

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

Yes, I tried filter Name Column, 4

The input datatable:


The output datatable(I added headers manually)

The output:
7

1 Like

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

@Celinnie Yey were almost there

3 Likes

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

cheers :smiley:

Happy learning :smiley:

4 Likes

I edited however, I still receive the same error.

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

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

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

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

cheers :smiley:

Happy learning :smiley:

3 Likes

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

@Celinnie
Later i will

cheers

3 Likes

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

thanks for your kind help!

2 Likes

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

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