04-11-2022 07:58 AM
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 🙂
Solved! Go to Solution.
04-11-2022 08:02 AM
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.
04-11-2022 08:02 AM
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.
04-11-2022 08:19 AM
Thank you @AleksandarAngelevski, should the target path column name prefixed with $?
04-11-2022 08:23 AM
It works either ways, with or w/o $ prefixed to target column name.
Thanks for the help though 🙂