topic RE: Filter Out Cell Value in Product Forum

Filter Out Cell Value

AsitabhaDeb — Wed, 28 Oct 2020 01:32:00 GMT

Hi Expert,

In the attach screenshots I would like to Filter Out Only "KB Order" type.
I have created custom BO under Excel VBO. when I am enter expression in "CriteriaToField" all the data are filter out from excel.
Can you please help me out .
In the excel Order Type is Fileld# - 2
For eg.

Order Type
KB
OR
ZSTK
I need to filterout only KB from excel. as this is huge excel file "Filter Collection" will not work.
Attachment for ref.

------------------------------
Asitabha Deb
------------------------------

RE: Filter Out Cell Value

Vamshi_KrishnaD — Wed, 28 Oct 2020 10:48:00 GMT

Hi

You need define the range and filter either in code stage you have to write

or use extended ms excel vbo - Auto filer

------------------------------
VamshiKrihsna Dasa
System Architect
Fujitsu India Consulting Pvt. Ltd.
------------------------------

RE: Filter Out Cell Value

MiguelCarrillo — Thu, 29 Oct 2020 04:36:00 GMT

In order to use the custom action that you create. You must select first the range of cells of your sheet and then appy the filter.

To select the range, you could use the action Select that its include within Blue Prim.
And then apply your custom action that you built.

If you have any doubts i could help you.

------------------------------
Miguel Carrillo
------------------------------

RE: Filter Out Cell Value

AsitabhaDeb — Thu, 29 Oct 2020 06:57:00 GMT

Thanks Migual,

Its working fine now.

------------------------------
Asitabha Deb
------------------------------