Inner join but with messy raw data

KNIME Analytics Platform
1

Hello, please find attached excel with raw data and the output i needed.
raw data is messy, can you help with the workflow?
the raw data is just a sample, the original raw data is with more rows but similar format
Thanks!!

Inner Join.xlsx (20.8 KB)

2

Why would a regular Joiner and Row Filter not work here…?

3

Hello @Aswin

In tab sheet “original file”, may i know how to add a new column and input the date?

thanks.

4

Ah, only now I understand your problem. I will have to think about it :slightly_smiling_face:. My first thought is to use a Recursive Loop, but that will be slow and quite complex…