3 Replies Latest reply: Oct 7, 2016 12:12 PM by Michael Solomovich RSS

    Multiple Columns Amalgamation

    Danny Vickery

      HI,

      I have a source excel sheet that I am trying to pull out the Part numbers from.

      Problem is there are 6 columns , Part Number 1, Part number2 etc all on the same row the same with part Qty.

       

      I want to take the information out of all 6 rows and be able to report how many times we have used the part in Qlik sense

       

      Any Ideas gratefully received!