Date Scaffolding - Join Dates with Less Than / Greater Than Function

[qdmt]

@Daniel_Weikert
I’ve experienced that in other workflows, but not this one. Not knowing exactly where you’re having issues, but generally speaking I found the Column Auto Type Cast node to be helpful in resolving column issues before they go into a DB node such as DB Writer.

[takbb]

@Daniel_Weikert

When I tried your flow I ran into an error
Did you experience something similar by any chance
“DB Writer Output type mappings are missing for columns”
KNIME 4.7 and I just run the downloaded flow

Hi @Daniel_Weikert
yikes! I just downloaded the workflow that I’d posted and it was actually the wrong one, lol. It wasn’t the one I showed in the screenshot and was an early version

I have updated the workflow in the original post. I’ll attach it again here for clarity. Can you give this one a go and check if it works for you.

Forum - Date Scaffolding - v2.knwf (1.3 MB)

Also, here is a link to the component which is now on the hub

Join Custom Condition - indexed – takbb

[takbb]

Hi @qdmt, Yes indeed… “Column Auto Type cast” is exactly what the later version of the component used! Unfortunately, as commented to @Daniel_Weikert , I originally managed to post the wrong version of the workflow. Well done for managing to make it work regardless!

And as you will see from the above post, the latest version of the component can be downloaded from the hub, so if it gets any bug fixes or other improvements, you’ll get them too. (The previously posted workflow didn’t have the hub-linked version in it)

[qdmt]

Thanks, I try to know at least a thing or two.