Filtering text and numbers (NaN) in same module

PhilipVs
PhilipVs
in Integrations and extensibility

Hi there,

 

I have one module(saved view) which is the basis for an export to another system.

This saved view consist of number and text (format), the export in the other system blocks when one of the number returns a NaN.

Therefore we need to exclude these NaN.

 

We thought we found a solution by creating a Line Item List from the module, and creating a boolean based on this.
However the LiS only works for number formatted items, and therefore excludes the text formatted if the filter is applied.

 

Anyone has some other suggestions to approach this?

Thank you in advance!

 

 

Tagged:

Answers

  • Misbah
    Misbah

    @PhilipVs 

     

    I believe you are converting the text into number format in your source module saved view. Create another line item which will say TEXT(Line item II)

    (Edited) - As per Best Practices

    Misbah_1-1616763967877.png

     

    and then filter on 

    Misbah_0-1616763948407.png

     

     

  • ChrisAHeathcote
    ChrisAHeathcote

    @Misbah 

    Could you use the following to populate the filter;

     

    NOT Number Line Item II = Divide(0,0) 

     

    Chris 

  • ChrisAHeathcote
    ChrisAHeathcote
    This approach doesnt work!!!
  • Misbah
    Misbah

    @ChrisAHeathcote 

     

    Divide(0,0) has an output of NaN. What he wanted was to exclude NaN so that all the numbers can pass from one module to another. Not sure what you mean by that. Am I missing something?

  • ChrisAHeathcote
    ChrisAHeathcote

    @Misbah 

    I was trying to use the NaN output from Divide(0,0) to filter out the NaN from the number column.

    But after testing I have found that it doesnt work as I thought it would.

    Chris 

Categories