How to load the QVS files?

[santharubban]

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.

[Gysbert_Wassenaar]

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.

[santharubban]

Hi

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

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