Sql to Altreyx

[Kavya432]

Is there any way we can covert this to Altreyx, especially the max of Date field?

SELECT
        ProducerFirst_Nm, ProducerLast_Nm,
             MAX(AgencyCancel_Dt) as lastest_cancel_dt
        
FROM RPT_AGSL_APPS2.A_ProducerHierarchy_AsIs

where ProducerFirst_Nm like'Abi%' and ProducerLast_Nm='IM'
group by 
        ProducerFirst_Nm, ProducerLast_Nm

[OllieClarke · Accepted solution]

@Kavya432 you could do this:

Although that is reading in all the data in the first place. 

Alternatively, as you're connecting to a database, you can edit the Table or Query and use your SQL

A third option would be to use the In-DB tools like so:

Or even to edit the query in the Connect In-DB tool (like we did in the input data tool)

Hope that helps, Ollie

[Kavya432]

That helps! Thank you!

[OllieClarke]

Hi @Kavya432 if you agree, would you mind marking my answer as a solution, so it can be easily found by other members of the community with the same problem?

Cheers