5 Replies Latest reply: Jul 6, 2016 10:56 AM by Silvia Brambati RSS

    ETL Script - how split data separate with ';'

    Silvia Brambati

      Hi All,

      i've  this table:

         

         

      Functional areaApplication NameKeywords
      FUN1Key1Key1; Key2
      FUN1AppApp; Actual; Flash
      FUN2Daily ViewKey1; Analysis
      FUN2TLC Key1 AnalysisKey1; Telecom; MMS
      FUN3Order in TakeOrdered
      FUN3FUN2les Analysis

      Backlog; Forward Orders


      The field Keywords contains words separate by ';' semicolon.

      I need to split this words and duplicate the rows.

      At the end, i want obtain this result:

         

      Functional areaApplication NameKeywords
      FUN1Key1Key1
      FUN1Key1Key2
      FUN1AppApp
      FUN1AppActual
      FUN1AppFlash
      FUN2Daily ViewKey1
      FUN2Daily View Analysis
      FUN2TLC Key1 AnalysisKey1
      FUN2TLC Key1 AnalysisTelecom
      FUN2TLC Key1 AnalysisMMS
      FUN3Order in TakeOrdered
      FUN3FUN2les AnalysisBacklog
      FUN3FUN2les AnalysisForward Orders

       


      I've to do this in ETL.

      How can i do it with script?

       

      thanks!!

       

      Silvia