topic Concat Function not Loading in App Development

Concat Function not Loading

etrotter — Thu, 31 Aug 2017 13:48:00 GMT

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 — Thu, 31 Aug 2017 13:50:47 GMT

May be this

MappingTable:

Mapping

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

Rename

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

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

sunny_talwar — Thu, 31 Aug 2017 13:52:07 GMT

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