Skip to main content
Solved

How to FILTER cell of COLUMN in excel based on COLOUR in FME ?

vimva679
Supporter
Forum|alt.badge.img+9

I have got an excel sheet and there are some cells with just colour and i don’t wish to include them for analysis purpose / output .

 

Without any edits in Excel sheet (eg. add some kind of numeric or standard text for colour cell etc.) i wish to remove or exclude. I also don’t wish to depend on any other column or cell value to filter rows with ORANGE colour cell 

 

I WANT to remove / exclude entire ROW that has yellow colour in cell in Column NCR Ref  

 

Best answer by danilo_fme

Hi @vimva679 

 

Attached the Workspace template developd in FME 2024 version.

View original
    Did this help you find an answer to your question?

    12 replies

    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • May 30, 2024

    Hi @vimva679 

     

    I suggest you enable the format attribute from Source:

     

    Read formating (.formating)

     

    After you can configure the transformer Tester:

     

     

     

    Thanks in Advance,

    Danilo

    vimva679
    Supporter
    Forum|alt.badge.img+9
    • vimva679Supporter
    • Author
    • Supporter
    • May 30, 2024

    Thank Danilo @danilo_fme for your quick response, i tried that for different column but look not getting it right 

     

     

     

    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme
    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • May 30, 2024
    vimva679 wrote:

    Thank Danilo @danilo_fme for your quick response, i tried that for different column but look not getting it right 

     

     

     

    Hi, I did understand the combination now. Please, wait some seconds.

    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • May 30, 2024
    danilo_fme wrote:
    vimva679 wrote:

    Thank Danilo @danilo_fme for your quick response, i tried that for different column but look not getting it right 

     

     

     

    Hi, I did understand the combination now. Please, wait some seconds.

    Please - could you share me your input data?

    vimva679
    Supporter
    Forum|alt.badge.img+9
    • vimva679Supporter
    • Author
    • Supporter
    • May 30, 2024

    Hello @danilo_fme please find the sample file attached. The text is inconsistent and it changes from file to file. So only common thing is colour of the CELL

    1 Attachments
    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme
    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • May 30, 2024
    vimva679 wrote:

    Hello @danilo_fme please find the sample file attached. The text is inconsistent and it changes from file to file. So only common thing is colour of the CELL

    Thanks for your data. In a few minutes - you will have the results :)

    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme
    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • Best Answer
    • May 30, 2024

    Hi @vimva679 

     

    Attached the Workspace template developd in FME 2024 version.

    1 Attachments
    vimva679
    Supporter
    Forum|alt.badge.img+9
    • vimva679Supporter
    • Author
    • Supporter
    • May 30, 2024

    Excellent , it works perfectly , thank you so much for great learning. Highly appreciate and obliged with your quick response. I tried it 2022.2 FME version and its works as well :) . 

     

     

    danilo_fme
    vimva679
    2 people upvoted this
    • danilo_fme
      danilo_fme
    • vimva679
      vimva679
    danilo_fme
    Evangelist
    Forum|alt.badge.img+44
    • danilo_fmeEvangelist
    • Evangelist
    • May 30, 2024
    vimva679 wrote:

    Excellent , it works perfectly , thank you so much for great learning. Highly appreciate and obliged with your quick response. I tried it 2022.2 FME version and its works as well :) . 

     

     

    Awesome. I’m happy to help you!

    jkr_wrk
    1 person upvoted this
    • jkr_wrk
      jkr_wrk
    vimalvaghani
    Participant
    Forum|alt.badge.img+1

    So @danilo_fme please on another know-how does it mean if I want to find or identify if any STRIKED records in Excel sheet,then I type “Strike” in (Right Value )and it would pass entire rows / cell in rows that are striked off i.e. Strike and Not Stiked rows could as well be seperated likewise separating records based on CELL colour? 

    Also where can I or which documents on FME could I find such settings or commands please /Br 

    jkr_wrk
    Influencer
    Forum|alt.badge.img+29
    • jkr_wrkInfluencer
    • May 30, 2024

    Here is some explanation:

    https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm

    💡 Did you know... The FeatureWriter is more intuitive. 😏
    vimva679
    Supporter
    Forum|alt.badge.img+9
    • vimva679Supporter
    • Author
    • Supporter
    • May 30, 2024

    GOT it right now : STRIKEOUT 

    jkr_wrk
    1 person upvoted this
    • jkr_wrk
      jkr_wrk

    Reply


    Helpful Members This Week

    Community Stats

    31,140
    Posts
    118,062
    Replies
    38,759
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.