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
      16Q1200180150120
      16Q2150200120180
      16Q3220200160140
      16Q4180220180200

       

      And I want it like this

      QuarterCol2Col3
      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

      http://kb.tableau.com/articles/knowledgebase/addin-reshaping-data-excel

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

       

      Thank you.