Forum Discussion

marenas's avatar
marenas
Contributor
4 years ago

Worksheet Writer - Cannot lookup a property on a null value

Hello! I am having an issue with the Worksheet Writer snap. As you can see below the Mapper snap has output value for $date_of_this_report field but when I map this to the Worksheet name, th...
smudassir's avatar
smudassir
Employee
4 years ago

@marenas , we do not support upstream values for worksheet name in the worksheet writer snap. You can use only pipeline params in the expression. The reason for not supporting upstream values are below:
- all data will not be written to single worksheet
- different rows can go to different worksheets, and this isn’t a good design.

Its only Worksheet Reader that can accept upstream values.