We have a set of data, shown in the screenshotted workflow, that we are looking to properly display date and time on using Knime. Each row is a value which corresponds to a start and finish date, as well as a time column that shows an elapsed time (number of days) that it took each row to be completed.
What we’re looking for is the best way to show each row’s start date, finish date, and time data. We have tried using the Pivot Node, but so far have been unable to yield what we’re looking for. Any suggestions or guidance would be appreciated!
Hi @Blake_Watkins , did you intend to attach a screenshot?
If you can upload some sample data with anything sensitive removed (e.g. as an excel spreadsheet, csv file or similar) along with an example of the expected output, that would make it easier for people to assist and provide you with suggestions or an example solution.
Hi @Blake_Watkins , what format are you wanting the output to take?
You said : “What we’re looking for is the best way to show each row’s start date, finish date, and time data” but since that information is already in each row what else are you wanting to do with this information? I’m assuming you want to transform it in some way but maybe you can elaborate with an example of how you’d like it to appear.
If you are able to upload some physical data as a file, that will always be helpful as otherwise to build an example workflow people have to type some data in which often means you’ll get fewer responses.
So, we’re really just looking to see what different ways KNIME can display the data. We don’t have one specific way in mind, just wanted to see what would be most effective. I will dive in and see if there is some physical data I can add and place it here.
What we are looking to display is the elapsed time between each step listed as a column name. (e.g. time between step 3.2/column C and step 3.3/column D and step 3.10/column E)
Hi @Blake_Watkins , can you describe the meaning of the data as I don’t understand what your spreadsheet is showing, or how it relates to the original screenshot.
