Depending on what you want to achieve ...
You may have a look into the OTHERSYMBOL-functionality,
e.g. (aircode)
SET OTHERSYMBOL = +;
MainTable: LOAD .....;
Scope:
LOAD [Team category] as [Team (scope)],
[Team name] as [Team (detail)],
RevTarget,
[Sample Target],
[margin Target]
FROM
[Test Data.xlsx]
(ooxml, embedded labels, table is sample2);
CONCATENATE (Scope)
LOAD * INLINE [Team (scope), Team (detail), RevTarget, Sample Target, margin Target
+ , # , # ,# ,#];
LEFT JOIN (Maintable) LOAD * RESIDENT Scope;
DROP TABLE Scope;
This then will show "#" (or any other) in each related field
