topic Re: Nuul as Others in App Development

Nuul as Others

rathnam_qv — Fri, 11 Aug 2017 06:37:10 GMT

Hi All,

I have two fields one is coming from database and the second one coming from Excel. Joining these two using code and pulling these two fields into Table. For field1 there are few nulls in field2.

I want to assign those nulls as Others in the field2. How to achieve it?

PFA image.

Thanks,

Rathnam.

Re: Nuul as Others

Ivan_Bozov — Fri, 11 Aug 2017 06:53:49 GMT

Hello! Perhaps something like: If(IsNull('Field2'),'Others','Field2')

Re: Nuul as Others

rathnam_qv — Fri, 11 Aug 2017 06:55:03 GMT

Hi Ivan,

Thanks for your Time.

I tried that but not working.

Thanks,

Rathnam.

Re: Nuul as Others

sasiparupudi1 — Fri, 11 Aug 2017 07:33:17 GMT

Try

If(Len(trim(('Field2'))=0,'Others','Field2')

or post some sample data or a sample app

hth

Sasi

Re: Nuul as Others

Ivan_Bozov — Fri, 11 Aug 2017 08:12:37 GMT

Okay, I just checked and it works if the tables are joined in the script. Small example below:

Script:

Example:
Load
Supplier,
Country
Inline
[Supplier,Country
A,China
B,Japan]
(Delimiter is ',');


Outer Join Load
Supplier,
Code
Inline
[Supplier,Code
A,CN]
(Delimiter is ',');

Sheet:

Re: Nuul as Others

Fri, 11 Aug 2017 08:17:02 GMT

Hi Rathnam,

If you use these two tables auto link together, like this:

Then you can try the following expressions, these two both work effectively.

if(aggr(isnull(Field_B),Field_A),'Other',Field_B)

if(aggr(len(Field_B),Field_A)=0,'Other',Field_B)

Regards,

Nina

Re: Nuul as Others

rathnam_qv — Fri, 11 Aug 2017 10:05:08 GMT

Hi Nina,

Thank you very much.

This is Exactly working as i expected. To give Correct Answer i am not seeing that option in Actions so, i gave Helpful.

Thank u once again.

Rathnam,

Re: Nuul as Others

Chanty4u — Fri, 11 Aug 2017 10:05:17 GMT

try this in dim

if(IsNull(filed),Dim)

Re: Nuul as Others

Fri, 11 Aug 2017 15:46:15 GMT

Hi Rathnam,

My pleasure!

Nina