Pulling data from multiple excel

[Anonymous]

Hello All,

I have 4 excel files namely A, B , C and D

I want to pull only certain column from each excel file.

I know how to pull all column from all excel files.

But how can I pull only certain columns from each excel file. For example:

I want only Column 2, 3 from Excel A; Column 5 from Excel B and Column 1 and 8 from Excel C etc.

How to achieve this in Qlikview

[qlikwiz123]

Hi,

The simplest way is to go into the Script tab and select Table Files in the bottom pane. Select the Excel file you want to extract data from. This will open a window with all the columns and data in them. You will find a 'X' option on the right end corner of every column. You can delete those you don't want to include in your data extract. Also, if you want Excel labels to be included, you can change that from the Labels option.

[Anonymous]

Hi,

I am very familiar with that. I am also familiar with extracting details from multiple excels with multiple sheet.

But the problem is, qlikview extracts all the columns from all the sheets from all the excel.

PowerBi gives the option to delete unwanted data after the excels are read. But there are no such option in QlikView. The procedure you told can be done when extracting 1 excel file. How can i remove columns or select only those columns when we are extracting data from multiple excel file is my question.

Regards,

Siva

[qlikwiz123]

What I told you gives you the option to pull in only the desired columns from the Excel Files, unless you are talking about rows.

You can repeat the same step for every Excel file. Also, you can simply delete the Column names from the load script and keep only those you need.

I kinda don't understand why you say it is not possible to extract selected columns from multiple excel files.

[shiveshsingh]

can you share the data and required output? you can load all the excels, add flag or whatever and pull the required columns from different tables.

[Anonymous]

Oh ok. Thanks. All these days i had  a single script that pulls all the excel file from a folder upon running the script. I have not been selecting multiple excel by clicking "tables" multiple times

So what you mean to say that,

Click Table --> Select Excel file --> edit columns.

And repeat the same step for every excel file that i want to add and then click "Reload" right ?

[shiveshsingh]

Yes, give different excels different table names.

else share the excel, then i can understand more and you can get better answers

[qlikwiz123 · Accepted solution]

Yes. That's correct. You need to load each Excel file at once, and give different names for every table. While loading every excel, just select the columns you want to keep and remove the unwanted ones.

[Anonymous]

Thanks a ton

[Anonymous]

Thanks shivesh