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

[Digvijay_Singh]

I tried below in personal edition ver 11, its fetching values propely,  -

Directory;

LOAD AS as [42064],

     AT as [42095]

FROM

[..\..\..\175379.xlsx]

(ooxml, no labels, table is Sheet1);

[#3]

I was wrong, I have 2 UK excels files, and one of them has data until the column AR...

Now I've found the problem, I'll try to find a solution, because my initial solution is not valid anymore.

Thanks a lot Joe!

[sasiparupudi1]

I think your problem is *UK*.xlsx

One of your UK* file is not having all the specified columns and your script fails. It is not a qlikview limitation and qlikview can load AS as column1 and AT as Column2

HTH

Sasi