Import file minus first x rows

[AndyDDUK]

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 · Accepted solution]

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