Filter DataTable using specific condition

Help Studio
, ,
1

Hi Guys,

I’ve an Excel with 2 Columns and multiple rows.
image

Name Abbreviation
United States of America
New York NY
Australia
New Zealand NZ
India IND
Brazil

Conditions are as follows:

  1. If the “Name” whose character length exceeds more than 5, it should have abbreviation; if not than the whole row should be cut off and added to exception results.
  2. If the “Name” has the abbreviation than no problem at all.

Final output should a single DataTable containing only “Name” column.

Thanks in advance…

2

Hy @Abhishek_Changan,

I did understand exactly what you want. Could you explain again!?

Thanks

3

I Just want “Name” column when the “Abbreviation” column has the values…

can we do it with SQL or any other thing?

Please guide me with this…

Cheers

4

Hy @Abhishek_Changan

So you want to see only the Names when the abbreviation are not null?

I will prepare a workflow and post it here

5

Hy @Abhishek_Changan,

Please check my workflow. This is the Apply Filter Activity

image

Regards

FilterDataTableTest.zip (28.8 KB)

2 Likes
6

Hey,

Thanks William…

It worked…

Cheers,
Abhishek

1 Like
7

Hy @Abhishek_Changan,

So glad I could help!

Please mark my answer as the final solution :slight_smile:

Thanks

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.