Hi All,
Please suggest how to consider data from specific row of excel as initial few rows are not useful .
Thank you.
Solved! Go to Solution.
Hi @snagalapur,
If the first rows are not useful (and also not counting as headers), then just start importing from a specific line like:
If you have multiple null rows after the header, use a filter tool to filter out the first rows. You probably have some null values in a specific column until the point of the rows you actually want to use, just use the filter tool on that specific column and you'll be fine :-).
Greetings,
Seb
Hi @snagalapur,
When connecting to an Excel file you also have the ability to select a range or named range:
Thank you for help.
Hi Seb,
Thank you for help, because of file type i was unable to use this option.