Missing value in table script

[#1]

Dear all,

I have tried to assign misisng value in table with Unknown, but the script does not work.

SAP:
LOAD * INLINE
[
Group Name, Value
GA1234, 2897
GA4567, 7000
GA9831 ,1200
GA5671,9400
];

  POLFA:
LOAD * INLINE
[
Group Name
GA1234,
GA4567,
GA9831
];

  Group:
LOAD * INLINE [
Group
POLFA
]
;

JOIN (Group)
LOAD
[Group Name]
Resident POLFA
;

DROP Table POLFA;

LOAD
[Group Name],
if(Group = '-', 'Unknown', Group) as Group /*This does not work*/
Resident Group;

The problem is  that GA9831 cannot be assigned with 'Unknown'.

Could you please give me an advice how to handle this?

Best regards,

Cornelis

[#2]

Good to hear from you.

It sounds encouraging that there are people that are willing to help me on way, like you.

Have a great day.

[#3]

Good to hear from you.

It sounds encouraging that there are people that are willing to help me on way, like you and Kush..

Have a great day.