Inserting additional columns with Null values

Snap Packs
#1

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:

#2

Hi @darshthakkar,

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

image
image1165×292 20.8 KB

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

BR,
Aleksandar.

4 Likes
#3

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

#4

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

1 Like