2 Replies Latest reply: Oct 22, 2010 4:52 AM by beciafreestyle RSS

    Join columns if records are missing and differ

    beciafreestyle

      Hallo everybody,

       

      I have a small issue- I would like to join two columns to get one market segment column. Data looks like that:

       

      error loading image

      For some cases I don't have a market segment number (but market segment description is available, ex. Fish), while for others I just have a number (ex. 1200). Also there are some spelling mistakes in the Market segment column (ex. bread vs Bread). Additionally I have a list of all of the market segments numbers and their market segment description (excel file), which could be used. Does anybody have an idea how to join everything, so it makes sense and I finish with one market segment?

      I suppose I need to link list of all of the market segments numbers with my data, giving the condition that if the number is not available, than use market segment description.

       

      I would really appreciate your help, as I am trying to stop using Excel in such matters:)

      Beata