Multiple mapping

Mapování více polí pomocí Mapping

27. 12. 2018
MapFields:
Mapping LOAD SomeID, FieldA & '|' & FieldB & '|' & FieldC FROM SomeSource;

Results:
LOAD *,
  Subfield(ApplyMap('MapFields', SomeID, 0),'|',1) as FieldA,
  Subfield(ApplyMap('MapFields', SomeID, 0),'|',2) as FieldB,
  Subfield(ApplyMap('MapFields', SomeID, 0),'|',3) as FieldC;
SQL SELECT  SomeID, …
FROM …