ETL | Alter Columns Tile | 'add select all columns'

Options
kp13
kp13 Member
edited August 2023 in Magic ETL Ideas

For magic ETL, it would be lovely if we could have Alter Columns behave similarly as the Select columns having the ability to Add All columns.

Thank you!

Kristine Plunkett

3
Up
3 votes

Active · Last Updated

Comments

  • timehat
    timehat Contributor
    Options

    Hi, Kristine!

    With Alter Columns, any unreferenced column passes through the tile untouched. Can you clarify what you are wanting to do with “Add All”? Do you need to change data types for all columns or some other bulk column operation?

  • kp13
    kp13 Member
    Options

    Hi Timehat!

    That's correct, we are bulk renaming and data type altering for all columns that are coming in from dynamic API customer connector builds. This would allow us to have the ability to add all columns in bulk to then alter names and data types in a more expeditious fashion. Any new fields from the API will pass through as necessary..

    Thank you!

Categories