Jun 05 2018
- last edited on
Jul 12 2019
I am using Excel Get and Transform to load data from another excel workbook. My dataset in the excel has about 30 columns and 1500 rows. I use the "New Query - from workbook" and selects my workbook. It then displays a "Navigator" window which shows the sheets in my workbook. When I select the sheet I wanted, it loads a preview window with only 10 rows and 3 columns. I then select "Load", it loads the 10 rows into my new workbook. It is always loading only 10 rows and 3 columns. I thought it was only showing 10 as preview and will load all rows when I say Load, but that is not happening. I tried "Refresh All" also and it refreshes that 10 rows again.
I tried pulling the data from a website URL using the same way and in this case also I am getting only 10 rows.
Are there any other settings that I am not aware of ?
Any help appreciated.
Jun 11 2018 08:50 PM
Have you tried saving the workbook as a CSV. My guess is there is a problem with the Excel file. Try copy paste the data in a new file and see if it works.