Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi
I no need to concat the fields to form a single line.
I need to load the entries table into a single statement.