Sql to Altreyx

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

Data Investigation

Accepted answers

OllieClarke

@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

All comments

OllieClarke

@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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280