Hi from one my expression rule I am getting output as ; ; ; [value]; ; can yo

riyazs over 8 years ago

Hi from one my expression rule I am getting output as ; ; ; [value]; ; can you suggest me a function here which removes null values and gives me just [value].

thanks

Discussion posts and replies are publicly visible

0 Chris over 8 years ago

Try filternulls(). Additionally, we use a custom rule filterblanks() defined as:

=remove(ri!array,wherecontains("",ri!array))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jacob Cohen - Project Leader - Macedon Technologies over 8 years ago

Check out the reject() function. That achieve what you're looking for.
forum.appian.com/.../Looping_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
A Score Level 1
over 8 years ago

As Jacob says, reject() is what you're looking for - but surely you should fix the issue in the expression rule rather than just removing the nulls?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riyazs over 8 years ago

thanks for response what function I can use in reject() to remove blank space since fn!isnull is not working?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jacob Cohen - Project Leader - Macedon Technologies over 8 years ago

If it is a List of Text and if you have Appian Common Objects you can use rule!APN_isBlank. Otherwise, you will need to write a rule that checks for an empty string or null.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 riyazs over 8 years ago

thanks @jacobc
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nathan.schmitz
Certified Associate Developer
over 8 years ago

Using difference( pv!array, { null() } ) should also work and perform better.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel