topic How to load the QVS files? in QlikView

How to load the QVS files?

santharubban — Wed, 19 Dec 2012 11:15:48 GMT

Hi,

i need to load the QVS file to QVW. I need to fetch line by line ie)

CMSMap:

Mapping

LOAD LEGAL_ENTITY_PARENT_NAME,

[PARENT COMPANY NAME]

FROM

[\\CMS-HL Distinct code-name values sorted by name.xlsx]

(ooxml, embedded labels, header is 1 lines, table is [Sheet 1]);

i need to load the whole table into single line but now its loading separate lines.

Can any one help me.

Re: How to load the QVS files?

Gysbert_Wassenaar — Wed, 19 Dec 2012 15:22:42 GMT

I don't understand your question. A qvs file is usually a text file containing a qlikview script. You 'load' that with the include statement: $(include = c:\mydir\myscript.qvs);

If you want to load a table from an excel file into one line you can use the concat function:

CMS:

LOAD concat( LEGAL_ENTITY_PARENT_NAME&'-'&[PARENT COMPANY NAME] , ',') as OneLine

FROM

[\\CMS-HL Distinct code-name values sorted by name.xlsx]

(ooxml, embedded labels, header is 1 lines, table is [Sheet 1]);

My guess is this isn't what you want either, but it's not clear to me what you're asking for.

Re: How to load the QVS files?

santharubban — Thu, 20 Dec 2012 08:23:33 GMT

I no need to concat the fields to form a single line.

I need to load the entries table into a single statement.