Filter datatable with 3 condition

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

yes of course buddy
Cheers @mashy2

image

is this how the condition structured?

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

Nope, its a string :slight_smile:

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

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

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

Thanks

1 Like

No Worries
Cheers @mashy2

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

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

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

(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.

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

did that work buddy @mashy2

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