Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @aatish12345 ,
Is it possible to share the data?
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
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