Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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...
May be this
MappingTable:
Mapping
LOAD '$(vTable)' & '.' & Field as FieldName,
Rename
FROM [lib://AttachedFiles/FieldMap.xlsx]
(ooxml, embedded labels, table is $(vTable);
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...