Hi there, I have a simple question, but I cannot figure out the answer.
I would like to simply add a column to a table, and rename all values to a certain string.
For Power BI there is a way to do Gap Analysis, so I need to create a table like below:
In Power BI, there is a Visualisation for Gap Analysis, which requires the data to be in the above format.
At the moment I have my data like this:
Table 1 (Last week’s data)
Table 2 (This week’s data)
As far as I know Knime doesn’t have a Gap Analysis feature, or if it does I think it would be quite hard to use, and not as easy as Power BI.