Skip to Content

Data services excel load issues

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 #.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.
    Add comment
    10|10000 characters needed characters exceeded