Filter datatable with 3 condition

Help
1

Hi,

Can filter datatable activity perform this condition:

“Status” is empty AND (payment no = a OR reference=b)

Basically status is empty is necessary requirement to tag along either with payment no or reference.

Thanks

2

yes of course buddy
Cheers @mashy2

4

image

is this how the condition structured?

5

is cc_nos and mid_no are variable of type integers
Cheers @mashy2

7

Nope, its a string :slight_smile:

8

Then we need to mention like this in value @mashy2
for
“Status” Is Empty
AND “Pmt. Ref No” = “cc_nos”
OR “Reference No” = “mid_no”

1 Like
9

since i want to use filter data table activity,
is this correct?
image

10

cc_nos and mid_no are string values na
so we need to mention them between double quotes like this in value field
“cc_nos”
“mid_no”

Cheers @mashy2

11

Thanks

1 Like
12

No Worries
Cheers @mashy2

13

hI,

It seem if the bot only recognized the status is empty then condition is true.

What i want is, the bot only recognized these kind of condition:

1)status is empty and “Pmt. Ref No” = “cc_nos”

or

2)status is empty and “Reference No” = “mid_no”

if only status is empty is present then there will be no data to filter.

is there anyway to perform this?

1 Like
14

may i know what is the condition that is exactly needed buddy
Cheers @mashy2

15

keep the status condition at last @mashy2
like this
“Pmt. Ref No” = “cc_nos”
OR
“Reference No” = “mid_no”
AND
Status IS EMPTY

16

(Status = empty and Ref=a ) OR (Status= empty and Pmt=b)

Somehow the earlier condition statement will also filter data if only the condition Status= empty is present.

What i want is: Status=empty must be accompany with condition Ref or condition Pmt. Then filter will be valid.

17

well in that case use two separate filter datatable and mention the condition in first filter datatable like this, and get the output with a variable named Final_dt_1

Status IS EMPTY
AND
“Reference No” = “mid_no”

and in the second filter datatable use a condition like, get the output as Final_dt_2
Status IS EMPTY
AND
“Pmt. Ref No” = “cc_nos”

Then use a MERGE DATATABLE activity where mention the source as Final_dt_2 and destination as Final_dt_1
so finally the datatable named Final_dt_1 will have the data you want

And the reason for creating two filter datatable is the condition is of that kind, so to make it feasible, i m suggesting this buddy
Cheers @mashy2

18

did that work buddy @mashy2

19

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