Magic ETL Python script
Hello. I can't find any example to run a Magic ETL Python script.
I have added a column. I want to populate it with a pythons script and it never works
in the schema tab I have added a new text column named : "Alias" and here is my script :
# Import the domomagic package into the script from domomagic import * # read data from inputs into a data frame input1 = read_dataframe('dataset') # write your script here # i dont know how to add a property "Alias" to input1 : here is what i have tried : input1["Alias"] = "test" # write a data frame so it's available to the next action write_dataframe(input1)
I know I can achieve it with a simple "Add constants" but I would like to know how to use python script.
0
Best Answer
-
Have you looked at the schema tab on the script tile? Does it appear after you run a preview? https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/ETL_Actions%3A_Scripting#Populating_The_Resulting_Schema
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部