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 …