I’ve an Excel with 2 Columns and multiple rows.
United States of America
New York NY
New Zealand NZ
Conditions are as follows:
- 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.
- If the “Name” has the abbreviation than no problem at all.
Final output should a single DataTable containing only “Name” column.
Thanks in advance…
I did understand exactly what you want. Could you explain again!?
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…
So you want to see only the Names when the abbreviation are not null?
I will prepare a workflow and post it here
Please check my workflow. This is the Apply Filter Activity
FilterDataTableTest.zip (28.8 KB)
So glad I could help!
Please mark my answer as the final solution
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.