Concatenate files from sharepoint

[ScottF]

My mistake. I thought you could do this with the Table Manipulator (and I’m of the obstinate opinion that it should work that way ) but in practice what you need is the Column Auto Type Cast node. That should convert types of ? to String.

[Melanie_CH]

Hi!
I am trying with the node you mentioned but I still get an error what could it be? looks like there is just one column that it doesn’t manage to change it

[Melanie_CH]

Also is there a way that I don’t need to reset the Microsoft Authentication node every time I run the flow?

[ScottF]

Well, what error are you getting now? The same one, or something different? At the same point in the workflow or elsewhere? We need more information to diagnose.

[Melanie_CH]

Hi Scott ! I am getting the same error in the same point

[Melanie_CH]

[mlauber71]

@Melanie_CH maybe you could tell us what this error message is. Maybe best to provide a Logfile in DEBUG mode:

Files Corrupted During File Transfer

@djarrett I could not initially find any problems. You could get rid of the vernalis error messages by installing RDKit. Could you create a LOG in DEBUG mode? Open the existing log and delete the content: [image] or delete the file from the workspace directory {workspace_directory}/.metadata/knime/knime.log activate the DEBUG level. Make sure that it would not contain any sensitive informations and remember to set it back to WARN after you are finished: [image] You might want to include f…

[Melanie_CH]

The error is this one

[ScottF]

You need to look carefully at the field that has a type of ?. In particular, WHY does it have that type? What fields are you combining from other datasets that would cause that to happen? Then, backtrack from there to try to solve the issue.

We also can’t see the configuration of the Column Auto Type Cast node to see how you are applying it. In cases like this, it’s better to upload a reproducible example of your workflow using dummy data, instead of screenshots.