Concat Function not Loading

[etrotter]

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);

[sunny_talwar]

May be this

MappingTable:

Mapping

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

            Rename

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

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

[sunny_talwar · Accepted solution]

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...