I’ve shared my flow. The group of nodes at the top is the flow I’m attempting to duplicate. The group below is working with my data.
The following is my issue. I’m attempting to create a filter via string manipulation variable node, like the original. It seems like I’m doing exactly what I need to do, but I’m not yielding any filtered results. I’m assuming it has to do with the date format, but I do not understand how to fix this.
In my flow, I’m converting my date into a string like the original, but I think ideally, I’d keep this as a date throughout.
i have data consisting of placement name, demo group, and tracked ads. the tracked ads are logged cumulatively by date. i need to calculate the number of tracked ads for each placement name, per demo group, each day.
i discovered this flow which is doing exactly that, the problem is they do it by period, im doing it by date and the format of the columns is throwing me a curve ball.
I apologize. I probably did not share it properly. I exported my workflow and attached it to original post. What’s the best way to show you my flow and data?
No worries.
The easiest way is to save the data within the workflow data area.
Go with you file browser to the workspace folder and then to your workflow.
In my case it would be in: “C:\Users\andi\knime-workspace\Forum\Kyleengs_Question”
Create a folder called “data”
Copy the excel file and/or the csv file to this folder
