topic Re: Concatenation fields having spaces in QlikView

Concatenation fields having spaces

satishsure — Tue, 13 Jun 2017 16:43:49 GMT

I have field called "Net Value" which has space.So I could not be able to use it from the Excel.

LoadList:

LOAD * INLINE [

FileName,FieldList

'load20','GrossValue,Net Value"

];

LET vLoadFieldList = Peek('FieldList',0,LoadList);

LOAD

$(FieldList)

FROM

[$(Transfilespath)$(Transfilename)]

(ooxml, embedded labels, table is dt);

sunny_talwar — Tue, 13 Jun 2017 17:13:47 GMT

Try this

LoadList:

LOAD * INLINE "

FileName,FieldList

'load20','GrossValue,[Net Value]'

LET vLoadFieldList = Peek('FieldList',0,LoadList);

LOAD $(vLoadFieldList)

FROM [Del1.xlsx]

(ooxml, embedded labels, table is val1);

DROP Table LoadList;

satishsure — Tue, 13 Jun 2017 17:50:51 GMT

Will Check ..Thank you..Sunny..:-)

satishsure — Tue, 13 Jun 2017 17:51:16 GMT

I have another issue like.I have file name contains "Trans Sales 2016.xlsx". file name has spaces

I need to verify the file name has 2016 or not not.

let vfile2016 = 'Trans Sales 2016.xlsx';

Let vfilename = 'Trans Sales 2016.xlsx';

if( WildMatch(($(vfilename)), $(vfile2016)) >= 1 Then

Concatenate (Data1);

end if

exit SCRIPT;

sunny_talwar — Tue, 13 Jun 2017 18:04:45 GMT

May be within single quotes

IF WildMatch('$(vfilename)', '$(vfile2016)') Then