6 Replies Latest reply: Oct 21, 2014 12:45 PM by Massimo Grossi RSS

    Categorizing / Bucketing Data using Excel

      Hi,

       

      I have a Field called "Event" with lots of different events. The problem is that they all have different text within them including the company name. I want to be able to filter on the event type which is not possible at the moment.

       

      event dateTickerCompany NameEventEVENT TYPE
      20/10/2014SAPG.DESAP (Ordinary Share)Q3 2014 SAP SE Earnings Call
      20/10/2014SAPG.DESAP (Ordinary Share)Q3 2014 SAP SE Earnings Release
      06/11/2014SIEGn.DESiemens AGFull Year 2014 Siemens AG Earnings Conference Call
      06/11/2014SIEGn.DESiemens AGFull Year 2014 Siemens AG Earnings Release
      11/11/2014TW.LTaylor WimpeyTaylor Wimpey PLC Interim Management Statement Release
      12/11/2014HAYS.LHays plcHays PLC Annual Shareholders Meeting
      12/11/2014WBSV.VIWienerbergerQ3 2014 Wienerberger AG Earnings Release
      09/12/2014SIEGn.DESiemens AGSiemens AG Capital Market Day "Vision 2020"
      08/01/2015HAYS.LHays plcHays plc Trading Update for Quarter Ending 31 December 2014

       

       

      Would be great if I could create a new field Called "Event Type"  and have the ability to filter on unique Event Type.

       

      Would be useful if I could bucket these categories in an Excel file ?

       

      i.e   State the search string in one column and the final "Event Type" in another.

       

      Search textEvent Type
      Earnings CallEarnings
      Earnings ReleaseEarnings
      Earnings Conference CallEarnings
      Interim Management StatementInterim Management Statement
      Capital Market DayCapital Market Day

       

      Can anyone please help on this?

      Many thanks,

      T