Select vs Dynamic Select (What’s the Difference?)

FAQs
1

Select Node

  • You manually pick columns

  • Column order is either:

    • exactly as listed (propagation OFF), or

    • same as input data (propagation ON)

  • Best when your schema is known and stable

:backhand_index_pointing_right: Think: “I know exactly which columns I want.”

Dynamic Select

  • Columns are picked automatically at runtime

  • You select by:

    • data type (string, numeric, date, etc.)

    • or a rule/expression like IsNumeric = true

  • Can invert selection (select everything except matches)

  • Usually preserves input column order

:backhand_index_pointing_right: Think: “Schemas change, I want rules—not hardcoding.”

Quick Rule of Thumb

  • Fixed schema? → Use Select

  • Changing / unknown schema? → Use Dynamic Select