Inserting additional columns with Null values

[darshthakkar]

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 reading the documentation, the best practice suggests that both the inputs should have consistency else the output would be some unexpected data.

While using mapper snap, I tried adding additional columns but it gives me an error saying that it couldn’t find the column_name (that I’ve added), how do I resolve this error?

Thank you in advance for your help 🙂

[Aleksandar_A · Accepted solution]

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]

Thank you @AleksandarAngelevski, should the target path column name prefixed with $?

[darshthakkar]

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