Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Inserting additional columns with Null values

How can we add additional columns with Null values using a mapper snap? Rationale behind this question: I’m trying to use a Join snap wherein Input 1 has 1 column and Input 2 has 50+ columns, after...
pipeline
  • Aleksandar_A's avatar
    Aleksandar_A
    4 years ago

    Hi @darshthakkar,

    Try using the mapper snap with Null-safe access checked. Like in the picture below:

    Try this, and let me know if this helps you.

    BR,
    Aleksandar.

Aleksandar_A's avatar
Aleksandar_A
Contributor III
4 years ago

Hi @darshthakkar,

Try using the mapper snap with Null-safe access checked. Like in the picture below:

Try this, and let me know if this helps you.

BR,
Aleksandar.

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      It works either ways, with or w/o $ prefixed to target column name.
      Thanks for the help though 🙂