Conditonal Filtering

I have a problem statement wherein I have an input file that changes daily and I need to filter a column(Subject) based on a condition that creates a table if value : 'English' is present in the column 'Subject' then Filters only on English else when value: 'English' is not present then it does not creates any table.

INPUT1 :

Subject	Marks
English	10
English	20
Maths	30
English	20
Maths	10

OUTPUT1 :

Subject	Marks
English	10
English	20
English	20

INPUT2:

Subject	Marks
Maths	10
Maths	20
Maths	40
Maths	40

OUTPUT2:

'No Records for Subject: English were found'

Custom Tools

Common Use Cases

Best Practices

Dynamic Processing

Data Investigation

Accepted answers

atcodedog05

Hi @sanketkatoch05

Here is how you can do it. Hope you have version 2020.2 or later this uses data cleanse tool feature from that. If not let me know.

Case1: With

Case2:

1. Using filter tool to keep only English.

2. Using count records to get row count with English.

3. Using append tool to add count to the data.

4. Using formula tool to check if count>0 or not. If count=0 output comment if not output rows.

5. Data cleanse tool remove null columns. This is used to keep only needed columns.

This way we can simulate the required output.

Hope this helps : )

English.yxmd

atcodedog05

Hi @sanketkatoch05

Its 2 usecases for 2 inputs scenarios. You just need only one workflow where input will be feeded in.

Hope this helps : )

English - WF.yxmd

All comments

JosephSerpis

Hi @sanketkatoch05 can you use a filter tool for this with the Subject of english?

Filter_12072021.yxmd

atcodedog05

Hi @sanketkatoch05

Here is how you can do it. Hope you have version 2020.2 or later this uses data cleanse tool feature from that. If not let me know.

Case1: With

Case2:

1. Using filter tool to keep only English.

2. Using count records to get row count with English.

3. Using append tool to add count to the data.

4. Using formula tool to check if count>0 or not. If count=0 output comment if not output rows.

5. Data cleanse tool remove null columns. This is used to keep only needed columns.

This way we can simulate the required output.

Hope this helps : )

English.yxmd

sanketkatoch05

Hi, thank you for the replies.

But in both the solutions, you guys are using 2 different inputs. My query was regarding only one input file because it is dynamic in nature. Sometimes it contains English sometimes it doesn't.

I wanted to create a single table wherein if no English records are found the Table tool should show 'No Records for Subject: English was found' and if there are English records then it gives a table for it.

atcodedog05

Hi @sanketkatoch05

Its 2 usecases for 2 inputs scenarios. You just need only one workflow where input will be feeded in.

Hope this helps : )

English - WF.yxmd

sanketkatoch05

Thank you @atcodedog05 .

This helps a lot. 🙂

atcodedog05

Hope this helps : ) @sanketkatoch05

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703