Filter Out or Remove

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.

Filter out.PNG

Hoping for your assistance.

Thanks

Kamen

Workflow

Datasets

Input

Best Practices

Documentation

Accepted answers

binu_acs

@KamenRider

you can add a filter again and based on the count field setup the email tools

Not ItesmsFound_20052024.yxmd

All comments

ChrisTX

Use a Count tool, then Append Fields, then Filter, then Select (to remove the Count field)

Can you post data in table format or Excel attachment, not as an image?

KamenRider

Hi @ChrisTX

Here is the file for your reference.

Thanks,

Kamen

Filter Out.xlsx

binu_acs

@KamenRider Just wondering a simple filer tool wont work for your usecase?

KamenRider

Thanks for the response @binu_acs , however my problem is that when there is no data, the filter will still filter out the "NO ITEMS FOUND". This should not be the case. If there is no data, the report will be "NO ITEMS FOUND". But if there is data, the report will shows only the data excluding the "NO ITEMS FOUND"

Please let me know if you have any questions.

Thanks,

Kamen

Raj

@KamenRider share same sample data and expected output
this will help to get more clarity on your requirement.

binu_acs

@KamenRider

Not ItesmsFound_20052024.yxmd

KamenRider

Hi @binu_acs

Thanks for the workflow however is it possible if we can merge this workflows into one. Conditions is that if "No Items Found", there is an email that will send this info that "No Items Found". But if there are records found, the email will state "Please review the attached report for any required action". Can we make this automatic wherein Alteryx will be the one to determine and send the appropriate email?

Hoping for your assistance on this.

Thanks,

Kamen

binu_acs

@KamenRider

you can add a filter again and based on the count field setup the email tools

Not ItesmsFound_20052024.yxmd

KamenRider

Hi @binu_acs

I am happy about the solution since we are nearing to complete it. Can I ask again for your expertise since the table below has text tool on it and whenever I run the table although there is no table since I have data, the said part is producing email because of the text tools attached to the layout tool. I am been thinking these for hours and I can't derived a solution. When there is no table since "No Items Found" is being filtered out when there is data, regardless there are text tools, there should be no email. Can you help me on this?

Table Restrict.PNG

Looking forward for your response.

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

binu_acs

@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 @binu_acs

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703