cancel
Showing results for 
Search instead for 
Did you mean: 

HCI-4DS: How to change '?' for missing descriptions to 'NULL'

0 Kudos

Hi,

How can I change value for missing descriptions from '?' to something else (ex. 'NULL' value)?

I tried to change $G_DEFAULT_TEXT global variable but it doesn't work.

Accepted Solutions (1)

Accepted Solutions (1)

Alecsandra
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sergey,

They will not be sent to IBP as '?' but as NULL (empty).

As far as I know this is how they are displayed in the design time data viewer only.

Regards

Alecsandra

0 Kudos

Hi, Alecsandra.

Yes, you are right - in IBP it's empty. How can I change it to anything else?

Alecsandra
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Sergey,

You can change the mapping in the target query to include a defaulting rule:

ifthenelse (XXX is null, 'NA', XXX)

Regards

Alecsandra

0 Kudos

Thank you

Answers (0)