Option to add prefix in Magic ETL Joins

NateBI

The Pandas library and Power Query have this option, it's the option to add the table name as a prefix when joining tables. Huge benefits when working with system-generated datasets for example that can have 40+ columns with similar names in each table.

The workarounds mentioned here don't quite cut it - if you're used to this feature.

Magic ETL Joins - include table name as prefix

NateBI

Jan 9, 2023

Hi All,

When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns?

Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.

Currently renaming columns but surely there's a better way:

https://us.v-cdn.net/6032830/uploads/DOJS1EIQMYX7/image.png

Let me know!

Kind regards,

---

View Post