Hi guys!
I’m trying to translate MS Access queries to KNIME. can someone explain to me how to translate this specific query? so far I have only done 2 correlations so its just a joiner node but this time it is 3 tables corellating.
also, what does the “Is Null Or” function mean?
thank you!
Replicating functionality is always the worst approach if you are supposed to work / maintain something in the long run.
Someone created something in MS Access given the capabilities of MS Access.
Better try to understand what the purpose is, what it is supposed to achieve. If you know that come back with a sample of the data and ask for an approach to resolve what you are trying to achieve. Better even, bring your first draft and people will be more likely to hint you in a direction.
To give you a starter, regardless of understanding the actual issue / task: You can chain joiners and Value Lookups to combine multiple tables stepwise. To include or exclude rows given a certain criteria, you can use e.g. the Row Filter
@kelvinlazam this seems to be a database also with primary keys and possible restrictions. Question is if you want to replicate that too. An alternative could be to use a local standalone database like H2 or SQLite as a replacement if you do not want to use MS Access.
