11 Replies Latest reply: Aug 9, 2016 4:13 PM by Vishwarath Nagaraju RSS

    combine two excel files into one qlikview file

    ROSANNA LUO

      Hello,

       

      Building metric from two excel files with different data values. Is it possible? From my research I bumped into many tutorials on how to merge multiple sheets/files with same header rows. In my case, I would like to combine the two files

       

      I attach a sample file with nonsensical data value. The end goal of this spreadsheet is on tab "Goal". Please note that the sample file is combined into same file for convenience purpose, in reality they're two different files.

       

      Please let me know if anyone has some thoughts on this. Thanks! I need some insights on how to make this happen, or if it's achievable at all.