I am not allowed to have Microsoft Access installed on my machine, so I have to get in another way using Knime. Unfortunately, I have come across a table where a lot of values are showing as “[lnet.ucanaccess.Complex.SingleValue;@xxxxxx]”
Can anyone suggest what may be happening here and how I may be able to fix it and reveal the true value?
This is because these are multivalue fields and the driver seems to struggle with extracting them.
You although can use UCanAccess driver and in this case Python to extract the values. I wan not able to integrate the driver directly into KNIME so I went with Python instead. Should run on macOS and Windows machines.
You will have to modify the code though to extract your fields and databases but it should show you how this can be done.
Thanks for the help. Unfortunately, I do not have Python, nor do I know how to use it! A shame…perhaps I should just try to convince my IT team to allow me Access! Knime is very useful though as there are 32 individual files (for some reason) and it’s really easy to combine them in a loop. I shall have to find another way around it.
@JWebb with KNIME it is quite easy to handle Python tasks. Most of the setup is already prepared in the Conda Environment propagation and for the code itself you can ask Claude.ai or ChatGPT for help. Or you can just exchange the column names in the script.
