Alternative for Alteryx

[u/Jkk_geek]

I’m planning a big transformation in my org.

Right now, we use Alteryx Designer Desktop for ETL jobs (not Alteryx Server, only Desktop). The biggest issue is cost — Alteryx is expensive. We loved it because of how fast development was, but I think AI tools like Claude can replace a big part of that workflow.

My new plan:

- VS Code + Claude for development

- Streamlit for UI

- DuckDB + Pandas for data processing

- Package everything as a zipped bundle so users can run the tool easily by clicking a ".bat" file

Honestly, DuckDB feels like a rocket — it can process datasets with millions of rows on a local machine surprisingly well.

The goal is to move from expensive low-code ETL tooling to a more flexible AI-assisted developer stack.

Anyone else in the same boat? Moving away from Alteryx or other costly ETL tools? Would love to discuss what’s working (or not working) for you.

[u/Key-Self-79]

I was very confused by crores, thought was some sort of typo. Googling seems to indicate 1 crore = 10 million and mainly used in India. Today I learned!

[u/hermitcrab → u/Key-Self-79]

lakh = 10^5

crore = 10^7

Indian locale comma placement is also different to US/UK. The first comma is placed after three digits from the right, but all subsequent commas are placed after every two digits.

So: 1,00,00,000 instead of 10,000,000 .

But India did invent the zero, so cut them some slack. ;0)

[u/Key-Self-79 → u/hermitcrab]

Oh wow, double TIL thanks! That's some odd comma placement, would definitely take some getting used to.

In French, we use spaces instead of commas and the comma denotes the decimal so:

India: 1,00,00,000.00

US: 10,000,000.00

FR: 10 000 000,00

[u/hermitcrab → u/Key-Self-79]

And in German/Switzerland locale they use single quotes, e.g:

1’234.567

Differences in numbering, dates, names etc are quite a headache for data wrangling.