Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

etrotter
Contributor II

Concat Function not Loading

Hey, my function is not working and I am not sure why, any ideas?

thanks in advance!

        MappingTable:

     Load

          concat('$(vTable)' & '.' & Field) AS FieldName,

             Rename

FROM [lib://AttachedFiles/FieldMap.xlsx]

(ooxml, embedded labels, table is $(vTable);

1 Solution

Accepted Solutions

Re: Concat Function not Loading

Basically you don't need Concat to put two fields together... concat is used when you have to put values within a single field into a string...

2 Replies

Re: Concat Function not Loading

May be this

MappingTable:

Mapping

LOAD '$(vTable)' & '.' & Field as FieldName,

            Rename

FROM [lib://AttachedFiles/FieldMap.xlsx]

(ooxml, embedded labels, table is $(vTable);

Re: Concat Function not Loading

Basically you don't need Concat to put two fields together... concat is used when you have to put values within a single field into a string...

Community Browser