Schema and Meta Select Tiles

b_rad
b_rad Contributor
in Magic ETL

Does anyone know when and how to use the Schema and MetaSelect tiles in Magic ETL?

I searched for documentation and couldn't find any.

Thanks in advance for any help with this.

Bharath.

Tagged:

Comments

  • ArborRose
    ArborRose Coach
    edited May 29

    This page link is all I can find.

    https://www.domo.com/blog/product-innovations-announced-at-the-connections-tour

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • ColemenWilson
    ColemenWilson Coach

    Use case is when you want to edit the schema of a dataset. Here are the steps to use the tile:

    1. Drag the Schema tile onto the canvas and connect it to an input.  This surfaces the schema as a table with the Column Names, Expressions, and Data Types of the input. 
    2. Connect the Schema tile to other Magic tiles like the Formula, the String Operations, and more to revise the schema.  The Schema tile introduces a new data type called “Expression”.  Use the in-tool documentation in the Formula tile to see details about that data type.
    3. Once you have your schema exactly as you want it, drag out the Meta Select tile.  The Meta Select tile requires two inputs – the last tile in the path of your modified schema, and the original input itself.  The Meta Select tile applies the changes made to your schema to the input dynamically.

    In this example below, I've added "test." in front of each column name dynamically:

    Screenshot 2025-05-29 at 8.02.13 AM.png

    If I solved your problem, please select "yes" above

  • b_rad
    b_rad Contributor

    @ColemenWilson your answer helped and I was able to test and make it work. Thank you for your detailed explanation.

    Having said that, I would really like Domo to provide more documentation and examples on how to use this. Hope they do it soon.

  • AndreaHenderson
    AndreaHenderson Domo Product Manager

    Sorry for the delay, the Knowledge Base article is in progress and should be out soon.

    Domo Product Manager for Data Transformation (MagicETL)

Categories