Filter Out or Remove

[KamenRider]

Hi,

Can you please help me out in removing or filtering out "No Items Found" if I have other available data. "No Items Found" should only be use if there is no data. In the sample below, I have "abc" and "def" as valid data so "No Items Found" should not be there.

 

Hoping for your assistance.

Thanks

Kamen

[JBLove]

Another solution might be to just use a Multi-Row formula tool followed by a filter tool.

First Tool - Multi Row formula:

The multi-row formula tool will determine whether "NO ITEMS FOUND" is by itself, or with other rows.  The assumption I am making is that Corr Code is always populated with a value.

In the Multi Row configuration:

For Values for Rows That Don't Exist mark these as NULL.  Your expression would look something like this:

If [Corr Code] = "NO ITEMS FOUND" AND (!IsNull([Row-1:Corr Code]) OR !IsNull([Row+1:Corr Code])) THEN "" ELSE [Corr Code] ENDIF

Second Tool - Filter Tool

Now with the filter tool you can filter out the the Empty Corr Code values.  The expression would look like this !IsEmpty([Corr Code])

The result should then give you either one row that shows "NO ITEMS FOUND" or rows of data that don't have "NO ITEMS FOUND" in the Corr Code column.

[KamenRider]

HI @JBLove 

Thanks for the ideas. I was able to hide the "no items found" when not needed however the issue is the the two text tool that is being produce in the email even if the table "no items found" is excluded or removed. I would like both descriptions from the text tools to be hidden when there is no table so that no email will be produced.

Please send me sample workflow of your solution since I am more visual to check it than reading.

Thanks,

Kamen

[binuacs]

@KamenRider I am not quite following your ask. From my understanding you want the emails to be sent if there is data as well as no data, that is why i created with a filter and the T-anchor is attached to the one email tool which will send with the data and F-anchor will send email with only the information "no data found". 

But from your last email i can see that you are using a table tool in the F-anchor where there is only one data that would be "no data found". My question why are you using Table tool in the F-anchor of the filter tool, also why the two text tool is being used

[KamenRider]

Hi @binuacs 

There are text tools because aside from the table "No Items Found", there are descriptions that I need to add outside the table. What happens is that when I run the workflow and read records in the excel file, two emails have been received. One is the correct one stating to check the file for the presence of records and the other is those with description of the "No Items Found". There should be one email to received.  But do not worry, I was able to solve it by changing the position of the text tools. So every time workflow read with records, it only send one email stating to check the attached excel. And if there are no record, it proceeds to the second container and notify through email.

Below is what I did

 

Your ideas have help completed this workflow and I am very thankful for your patience. Acknowledging your workflow shared as solution.

Thanks,

Kamen