This is the data format I have but am unable to visualize variability by days for each item. Would like to transform this data into the below output format for ease of Charting and Graphs. Once all the data is in row format, filters and pivots can be used on column headers.
Look forward to suggestions. End visualization goal using Pivot / Knime is to have “Item Number” on x-axis, “Inventory” on Y-axis and “Day” as a filter.