Good day,
I am currrently doing data quality checks in Dataplex using a datawarehouse that im working with. I wanted to ask if theres a way of writing normal sql queries without Dataplex applying their own Select CountIF in my expressions. For example i have the following expression: sum(field1) = 1 AND field2= '' OR field2= "Unspecified" but its failing with the following error: Error: SELECT list expression references column Contact_WhatsappNumber which is neither grouped nor aggregated at [1:269]
Can someone please assist.
LinkedIn
Twitter
