I am an Alteryx user for roughly 10 months now and want to explore the opportunities Knime can provide me.
I am working in Finance and have a set of standard file formats to process. Unfortunately things seem to be highly complicated in Knime at first sight. I hope you can make my fears fade away :). I am not a coder but more a business user.
My common file formats to read/write back to are:
xlsm / xlsb files (ideally with the opportunity to select ranges)
welcome to the KNIME Forum! I am happy to hear that you are giving KNIME a chance to show how cool it is Regarding XLSM and XLSB: I think our Excel Reader (XLS) should be able to read XLSM files. XLSB is a bit more complicated and requires Python. There is an example workflow on the hub, though: https://kni.me/w/zlTBIedGQxtPg7je. Maybe that helps in that regard.
I don’t know if it is possible to read Hyper extract files in KNIME, a quick search does not turn up anything and so far I have unfortunately never seen it. I am not a Tableau user myself, but I wonder: could you export the extracts in a different format?
If you have any other questions during your KNIME discovery, please let me know, I am happy to help!
Regarding xslm: could you try to just enter the file path in the text field without using the Browse button? If that works, I can open an internal ticket for our developers to add xslm to the allowed extensions.
Often if you cannot find a genuine import node for a data format you could use R or Python to do the job which integrate into KNIME.
Concerning Tableau and hyper-Extracts there seem to be at least two promising packages that should be able to deal with the format. This is one nice thing about KNIME. It is open for connections. And even if you are not a coder. Most of the time a few lines will do the trick - if you make yourself a few working examples you could adapt them later.