search

amphi-ai / amphi-etl

Low-code ETL for structured and unstructured data. Generates Python code you can deploy anywhere.
https://docs.amphi.ai
Other
551 stars 12 forks source link

A formula transformation tool #27

Open simonaubertbd opened 1 week ago

simonaubertbd commented 1 week ago

Hello,

I would like to have a formula tool with these features (looks very classic): -modify an existing column or create a new one -if a new one, ability to set the type (with a dropdown menu as exemple) -autocompletion -preview -ability to disable a formula (not usual but when developing, it's pretty cool) -language should be python of course

For reference, the Alteryx formula

image

Best regards,

Simon

tgourdel commented 1 week ago

Hi Simon, That's a good idea. I do believe this can be done with custom code component but I see why it would help to have one and probably easier for people less comfortable with Python. I probably can have an experimental version of this pretty quick! Thanks for the suggestion!!