Solved: Import file minus first x rows

AndyDDUK · ‎03-03-2017

Hi there

Newbie here, how can I import a file and exclude the first 20 rows?

I'm aware that I can go into edit mode and delete these rows, but I want to set BI up so that each week when I receive the same file (updated with previous weeks data) I can run a query over the data without having to delete the rows each time

Many thanks

Andy

danrmcallister · ‎03-03-2017

Hi Andy,

I think editing the query should work. When you tell the query to delete rows or columns, you are building that into the query; each time it goes and refreshes the data, it'll run that logic as part of fetching new data.

Dan

View solution in original post

danrmcallister · ‎03-03-2017

Hi Andy,

I think editing the query should work. When you tell the query to delete rows or columns, you are building that into the query; each time it goes and refreshes the data, it'll run that logic as part of fetching new data.

Dan