Referencing Excel using columns

[Anonymous]

Good Evening,

     Earlier today I was testing my application which references Excel columns by the column letter e.g.

if (vFileExists) then

        NoConcatenate

          [Perf_file_Cockpit]:

            First 7 LOAD distinct

            RecNo() as RecNum,

                date('$(ExtractDate)') as ExtractDate,

                '$(i)' as Aircraft_SN,

                'Cockpit' as Major_Component,

                     C as Type,

                    D as SAT,

                    E as SUN

   FROM [lib://Raw_Data/Daily Ops Review Data V2.xlsx]

   (ooxml, no labels, header is 206 lines, table is [70016 Burndown Graphs]);

However, since receiving so production data and I have verified the source layout hasn't changed. I now get an error Field C not found.

Any thoughts, folks?

Brian.

[quriouss]

Three things I'd try;

1.  Are you sure you have 206 lines of headers?  (Nothing wrong with that, just checking).

2. Change the "no labels" to "embedded labels"(?)

3. Wrap the C, D and E in double-quotes (or square brackets)

                     as [Type],

                    as [SAT],

                    as [SUN]