Python Script Error and KNIME Workflow Guidance
I am trying to use Python to manipulate my Excel file. When I run the Python script on my Excel file in Spyder, it works perfectly with no errors. However, when I move the file to the Python Script node in KNIME, I encounter an error: ‘Execute failed: Row key checking: Duplicate key detected: “Row10”.’ I’m not sure what this means. I’ve attached the workflow and the output file I get when running it in Spyder for your reference
I suspect that KNIME’s node is identifying duplicate row keys (identifiers for rows). Which rightly so my output does contains duplicate row keys (identifiers for rows) for this step of the workflow, I will further remove duplicates in the later stage of the workflow. How do I overcome this error?
Additionally, i would like to ask how to view the output of my excel table post a successful processing of my python script? Will i be able to see under the table output section of the python script node? I just want to see it in the console if the data is processed successfully?
Also can I connect a Row Filter node to continue filtering my excel table post my python script processing? or I need to connect the python script node to a table writer node first then connect to a row filter node?
Thanks!