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 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 :slight_smile:

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.

4 Likes

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

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

1 Like