I have an excel datasource in which data is coming in format, attached is the screenshot. I received this excel file on daily basis and want to pull data only from table containing table name "PQR". Since, the files are changing row number of that table is also changing.
So, how can I implement this in qlikview. Please help.
Please upload a sample of the spreadsheet. You can load this in Qlikview, but the details are a little complicated. The screenshot is not very useful and without a sample, you might not get any accurate answers.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Thanks for sharing above line, but it doesn't work for me. In my case I have a file ,say Transaction 02-02-2016.xlsx. This files contain data divided in table format. Sample excel files has been attached above. I want to load data from single table "Transaction 2" and leave other tables untouched.