AND conditions for custom filter

[nithyas]

Hi all,

I have a requirement to combine data from two tables. In the current ETL tool, I could write a SQL. But in Alteryx, we chose to store the data in the .yxdb resulting which I cannot re-use the same query.

So, I am trying to build a workflow that uses the same SQL combining two .yxdb files. The conditions to filter out somehow doesn't seem to work.

SQL : TableA.<Field1> = 'XYZ' AND TableA<Field2> = 'ABC' and TableB<Field1> != null.

Tried to use the custom filter -

[Field1] = 'XYZ' AND [Field2] = 'ABC' and [Field1] != null().

When I use a single condition, I see the records, but not when I use the AND clause. C

Please assist.

Thanks!

[MarqueeCrew · Accepted solution]

Hi @nithyas,

You are close.

[Field1] = 'XYZ' AND [Field2] = 'ABC' and !IsNull([Field1])

That should do it.

Cheers,

Mark

[nithyas]

Thanks Mark! That helped.