topic Re: Script Format in QlikView

Script Format

priyarane — Wed, 22 Apr 2015 12:04:08 GMT

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

Re: Script Format

Anonymous — Wed, 22 Apr 2015 12:09:21 GMT

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

Thanks

BKC

Re: Script Format

Anonymous — Wed, 22 Apr 2015 12:14:43 GMT

Attach your sample file.

This source file is may be delimited file (CSV)

Re: Script Format

priyarane — Wed, 22 Apr 2015 12:20:53 GMT

I have the excel.

Re: Script Format

marcus_malinow — Wed, 22 Apr 2015 12:54:19 GMT

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