Display one row using table transformer macro?

[Jessica Luo]

I have the above table and I want to use the table transformer macro to only display the "complete' row. 

I tried to use a custom SQL query in the table transformer macro but it is not behaving how I expected.

I am using this query:

SELECT * FROM T1 WHERE 'STATUS' = 'COMPLETE'

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Jessica Luo,

Please use the following query:

SELECT * FROM T1 WHERE 'STATUS' = "COMPLETE"
As you refer to the value (string) and not the column, you should use not ‘COMPLETE’ but "COMPLETE" in your query.