Showing blank for null values

[aatish12345]

Hi Everyone,

Currently I have 2 tables associated with each other and in front end when I was using fields from both the tables, for few records Nulls are coming. Now in order to display a blank white space for those nulls, I had used below code:

NullAsValue *;

Set NullValue='  ';

After reloading I got few blanks and few nulls in the same field. I am not able to figure out why still nulls are showing in the field, when I wanted all the nulls should be blank.

Can anyone plz help!

Regards,

Aatish

[abhijitnalekar]

Hi @aatish12345 ,

Is it possible to share the data?

[aatish12345]

No it is not possible to share a data, but just for your understanding, want to provide some heads-up.

Table1:

ID, Name

1, Jack

2, Neil

3, Alex

Table 2:

ID, City

1, New york

2, London

3, Delhi

4, Melbourne

If the above data we took, we found that for ID 4 there won't be any name present in table1 and by default it will show as - along with grey bg. I want to show this missing data as total blank with white space, but it is not coming even after using NullAsValue function.

Hope this helps!

Aatish

[abhijitnalekar]

Hi @aatish12345 ,

have you tried applymap?

I would suggest using applymap after checking provided data.

please find below the script

map:
Mapping
LOAD
ID,
Name
FROM [lib://test/Testing.xlsx]
(ooxml, embedded labels, table is Sheet4);

LOAD
ID,
City,
applymap('map',ID,'not found')as Name
FROM [lib://test/Testing.xlsx]
(ooxml, embedded labels, table is Sheet5);

Let me know if this not work