Translate Alteryx Workflows in PostgreSQL
Budget: $10 – $30 USD
I am moving a small data-prep process out of Alteryx and into native PostgreSQL. There are six existing Alteryx workflows that read CSV files, apply a mix of data filtering, aggregation, and joining, then pass the results forward: the first three workflows each feed their output into one of the remaining three. Along the way the flows rely on custom calculations, conditional statements, and multi-table joins, all of which need to be faithfully reproduced in SQL.
Your task is to deliver one well-structured SQL script (or a clear set of scripts) per workflow so that I can run them inside Postgres and obtain identical results. Please keep the following points in mind while you work:
• Source data arrives as plain CSV
• Replicate every transformation step—including the custom logic—so downstream queries behave exactly like their Alteryx counterparts.
• Comment the code generously so that future tweaks are straightforward.
• My day-to-day SQL editor is Marimo, but anything that runs cleanly in PostgreSQL.
• Provide a short README explaining execution order, required temp tables (if any), and how each script maps back to the original workflow.
I will verify the conversion by comparing row counts and spot-checking values between the Alteryx outputs and your SQL results. Once everything matches, the job is complete.
Your task is to deliver one well-structured SQL script (or a clear set of scripts) per workflow so that I can run them inside Postgres and obtain identical results. Please keep the following points in mind while you work:
• Source data arrives as plain CSV
• Replicate every transformation step—including the custom logic—so downstream queries behave exactly like their Alteryx counterparts.
• Comment the code generously so that future tweaks are straightforward.
• My day-to-day SQL editor is Marimo, but anything that runs cleanly in PostgreSQL.
• Provide a short README explaining execution order, required temp tables (if any), and how each script maps back to the original workflow.
I will verify the conversion by comparing row counts and spot-checking values between the Alteryx outputs and your SQL results. Once everything matches, the job is complete.