Splitting a Column

Comments

3 comments

  • Konsta Danyliuk

    Hello Anson.

    Based on the provided source data, may I ask you to create a mock-up of the result you are looking for (you could create it e.g. in Excel)? It makes it easier to suggest the right approach.

    0
    Comment actions Permalink
  • Anson Chan

    Hello Konsta, thanks for coming back.

    This is what I have in mind and I seek your professional guidance on the best approach to deal with this

    Many thanks! happy new year!

    0
    Comment actions Permalink
  • Konsta Danyliuk

    Hello Anson.

    I would need the exact appearance of the source data, e.g. 5 records, and the result you need to get for these 5 records. From the sample, you provided it is not clear where the Hostname column is incoming from, as it is absent at the initial sample (the 1st screenshot you've shared).

    I already have some transformation steps in mind, but I need to know how exactly the source data looks like.

    0
    Comment actions Permalink

Please sign in to leave a comment.