3 Replies Latest reply on Dec 17, 2016 9:54 PM by Nagaraj Ganiga

    I need a KNIME node for data reshaping.

    Nagaraj Ganiga

      Hi all,


      I want to reshape my data,

      Say I have

      QuarterActual SalesTarget SalesActual ProfitExpected Profit


      And I want it like this

      16Q1Actual Sales200
      16Q1Target Sales180
      16Q1Actual Profit150
      16Q1Expected Profit120
      16Q2Actual Sales150
      16Q2Target Sales200
      16Q2Actual Profit120
      16Q2Expected Profit180
      16Q3Actual Sales220
      16Q3Target Sales200
      16Q3Actual Profit160
      16Q3Expected Profit140
      16Q4Actual Sales180
      16Q4Target Sales220
      16Q4Actual Profit180
      16Q4Expected Profit200

      I can do this in EXCEL, I have an Add-in to reshape the data for Tableau, this is the link


      Now can anybody please tell me is it possible to do it in KNIME using any nodes?


      Thank you.