cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting additional columns with Null values

darshthakkar
Valued Contributor

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 🙂

1 ACCEPTED SOLUTION

Aleksandar_A
Contributor III

Hi @darshthakkar,

Try using the mapper snap with Null-safe access checked. Like in the picture below:
image
Try this, and let me know if this helps you.

BR,
Aleksandar.

View solution in original post

3 REPLIES 3

Aleksandar_A
Contributor III

Hi @darshthakkar,

Try using the mapper snap with Null-safe access checked. Like in the picture below:
image
Try this, and let me know if this helps you.

BR,
Aleksandar.

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 🙂