Forum Discussion
Solved
Import file minus first x rows
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 receiv...
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
danrmcallister
Resolver II
Resolver IIHi 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