Skip to Content

Data services excel load issues

Dec 08, 2017 at 01:05 PM


avatar image

Hi Experts,

We receive data extract from source system in excel files and I have following issues in loading it using data services:

  • File name has date and time appended ,requirement is to pick up today’s file and process it.
  • First 2 rows of excel are the report name and requirement is to get the header and data from 3rd row.
  • Existing Column position keep changing with new field additions,for ex a new field might be added in middle rather than after last column which changes the column position of all the columns in right to it, is there a way to look for the column header name rather than column #.
10 |10000 characters needed characters left characters exceeded

Any help please

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
Dec 12, 2017 at 12:14 PM
  1. Use a variable to specify the name of the Excel file and use it for the File Name in the file Format properties tab.
  2. Use Custom Range line A3:X4 (with X denoting your last column) and check the Extend range property.
  3. Not possible.
10 |10000 characters needed characters left characters exceeded