Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Pasquale,
Did you try data transformation option. Try conditional delete in data tranformation.
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: