Script: cannot reload until column AS from the excel

[#1]

Hi Qommunity!

I'm trying to load an Excel file, where there are no headers, and I want to pick information until the column BN of the excel.

However, when I launch the reload, I always have this error: "Field not found - <AS>". When I comment this field, it says this is the next which cannot be found (AT).

My script is the following:

CS_SLA_1:

CrossTable(SLA_FECHA, SLA_NIVEL, 😎

LOAD

  'UK' AS PAÍS,

  '0000' AS COD_ENTIDAD_1, 

  A AS SLA_MODELO_OPERATIVO,

     B AS SLA_DEPARTAMENTO,

     C AS SLA_FUNCIÓN,

     D AS SLA_SERVICIO,

     E AS SLA_INDICADOR,

//     F,

//     G,

//     H,

//     I,

//     J,

//     K,

//     L,

//     M,

//     N,

//     O,

//     P,

//     Q,

//     R,

     S AS SLA_TIPO,

//     T,

//     U,

//     V,

//     W,

//     X,

//     Y,

//     Z,

//     AA,

//     AB,

//     AC,

//     AD,

     AE  AS [41640],

     AF  AS [41671],

     AG  AS [41699],

     AH  AS [41730],

     AI  AS [41760],

     AJ  AS [41791],

     AK  AS [41821],

     AL  AS [41852],

     AM  AS [41883],

     AN  AS [41913],

     AO  AS [41944],

     AP  AS [41974],

     AQ  AS [42005],

     AR  AS [42036],

     AS  AS [42064],

     AT  AS [42095],

     AU  AS [42125],

     AV  AS [42156],

     AW  AS [42186],

     AX  AS [42217],

     AY  AS [42248],

     AZ  AS [42278],

     BA  AS [42309],

     BB  AS [42339],

     BC  AS [42370],

     BD  AS [42401],

     BE  AS [42430],

     BF  AS [42461],

     BG  AS [42491],

     BH  AS [42522],

     BI  AS [42552],

     BJ  AS [42583],

     BK  AS [42614],

     BL  AS [42644],

     BM  AS [42675],

     BN  AS [42705]

FROM

[*UK*.xlsx]

(ooxml, no labels, header is 4 lines, table is [UK New]);

Do you know if this is a QV limitation?

Thanks a lot in advance for your help!

Regards,

Vincent

[Anonymous]

Try to use

"AS" as ....

"AT" as ...

...

[#3]

Thank a lot for your help Michael, but unfortunately, it didn't work 😞

[#4]

You could try [AS]

[#5]

Thanks a lot Aidan, but no luck neither 😞

[Digvijay_Singh]

Try 'AS'

[#7 · Accepted solution]

Hi Vincent,

you are doing a wildcard load of all the UK excels, are you sure for all of those files the fields do in fact exist and have data?

Try testing your code on a single excel which you know has all the columns populated first

hope that helps

Joe

[#8]

You could try Load * from the excel file.

Store this off into a qvd and re-load the data from the qvd and try renaming the columns possibly?

[#9]

Thanks Digvijay, but doing this, it changes the content of my column in text AS.

[#10]

Hi Joe,

I'm doing a wildcard load but there is only one UK file. The problem I have is that every month, the user will add a new column with the data of the month, and my idea was to prevent this problem by loading all the columns with already the date written. For this, I need a generic name which is the name of the excel column. Today, there is information available until the column AV.

Anyway, many thanks for your help!