Hi all, I think this is question with an easy solution. Only, I can't find it..
I have an excel sheet which I want to use every month for reporting. It is output from the finance system. The header has one blank cell (first cell). With change metadata I want to rename the blank to a new description. I used get metadata and transform. No errors there. Now when I connect the new metadata to the change metadata node and run, I get an error that the field "Null" does not exist in input data. Somehow it doesn't understand that the blank header cell should be replaced with the new description. The function NullHeaderCellAction in the Excel node is not work as the cell is not Null.
Hope someone has a solution. Thanks in advance!
Please sign in to leave a comment.