Script Format

[priyarane]

Hi Experts,

From the source(excel), how to achieve as below.

[RowHeaders]:

LOAD
RecNo() AS RowNo,
@1 * 10 AS Item,
If( IsNum(@1) , Peek(ItemTxt) , @1) AS ItemTxt,
@2 AS [Item Text]
FROM
Souce.xlsx
(ooxml, no labels, table is Sheet1, filters(
ColXtr(1, RowCnd(CellValue, 1, StrCnd(shorter, 0)), 0)
));

which format it is:
(ooxml, no labels, table is Sheet1, filters(
ColXtr(1, RowCnd(CellValue, 1, StrCnd(shorter, 0)), 0)
));

what is @1

[Anonymous]

@1 is your qv by default column names (labels) and you can achieve this ..

Thanks

BKC

[Anonymous]

Attach your sample file.

This source file is may be delimited file  (CSV)

[priyarane]

I have the excel.

[marcus_malinow]

In your load script you have 'no labels' set, so QlikView will refer to the first loaded column as @1, the second as @2 and so forth.

If you rework your load script and set it to 'embedded labels' you can refer to your field names as they are defined in your data source