topic Take the data from excel with specific rown e column in QlikView

Take the data from excel with specific rown e column

pascos88 — Mon, 23 Nov 2015 09:30:15 GMT

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

Re: Take the data from excel with specific rown e column

tamilarasu — Mon, 23 Nov 2015 16:56:09 GMT

Hi Pasquale,

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

QlikView Data Transformations in Flat Files — Mindmajix

Re: Take the data from excel with specific rown e column

petter — Mon, 23 Nov 2015 17:10:35 GMT

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: