How to make essentially an XLOOOKUP with multiple lookup value conditions?

[sunpixie2000]

I have two datasets, which need to be “joined” in such way, that I search for multiple column match end replace the values in the return area (which also has multiple columns).

Example:

Values to be searched: Invoice Number, Product, Serivce Type, Period, Product Category, Customer Name

Values to be replaced: Sales 2024-01, Sales 2024-02, Sales 2024-03, Sales 2024-04, etc.

Each dataset has the same columns so the values to be searched, can also be found in the dataset from which I want to take the values. And this dataset from which I want to take the value sand replace the values in the lookup dataset, has also the columns Sales 2024-01, SAles 2024-02, etc.

How should I approach the problem in KNIME?

[MartinDDDD]

Welcome to the Forum. Took the liberty to use my newly granted powers to move this out of Node Development and into the general Category where it is more likely that people will find this topic and can help you.

For queries like yours it is best if you can share “mock-up” data - both the source that you want to process and the outcome incl. explaining the logic. That makes it easier for users to help you out.