Concatenation fields having spaces

[satishsure]

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]

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]

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

[satishsure]

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]

May be within single quotes

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