Take the data from excel with specific rown e column

[pascos88]

Hello,

I have to take the data from an excel but with a particular format.

For exemple I need to take the column Name, start from D3 to D7.

The same for the age Id and City columns.

A simple "Data from file" sure can't work becouse I will have this results.

Someone can help me or advice me how I can have the separate column with the data that I need?

thanks in advance.

Regards

Regards

[tamilarasu]

Hi Pasquale,

Did you try data transformation option. Try conditional delete in data tranformation.

QlikView Data Transformations in Flat Files — Mindmajix

[petter]

You have in addition to what Tamil suggest at least two other options:

Create a Named Range in the Excel Sheet and call it TableTwo. Then you can select it directly under the Tables drop-down in the File Wizard:

If you can't change the source xlsx-file then you can just set the Header Size to 2 and Labels embedded and then exclude the three first columns by pressing the X in the column header:

Here is the two load-statements that both wizard options will create for you... select the one that suits your needs: