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.
Re: combine two excel files into one qlikview file
Ok. I believe the field name coming from one of the excel tabs is not correct. Can you cross check and modify the fieldname in Ex2 Table to what you have in the excel. Or send me the correct excel sheet i will populate again and modify and send you back.