Correction help needed in the script of attached app

[bhavvibudagam]

Hi Experts,

Can anyone please help me on below requirement.

Please help me on  avoiding null values under Team(scope) field.

Thanks in advance.

[settu_periasamy]

Maybe like attached?

[prieper]

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