Skip to content

    • Archive

    Archive

    Vlookup/Related Function

    Member
    in Archive

    Hello,

     

    I am working on a project that is combination of 3 excel coming from different servers.

    1.Shall I define the data flow? if yes do we have vlookup functionality to combine the 3 excel report, do I need to define the mapping ?

    2.Shall I upload the excel and then select the fields that I want from each excel

    What will be the best optimized solution?

     

    Best,

     

     

     

    Comments

    • Coach

      Upload your spreadsheets individually and then create a dataflow.  Using Magic ETL or a SQL dataflow, you can link your files on common columns, like customer ID or employee ID, as you would in a vlookup. In the same Magic ETL or a SQL dataflow, you can select which columns you want as a part of your final output (a fourth, combined dataset).

      Aaron
      MajorDomo @ Merit Medical

      **Say "Thanks" by clicking the heart in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories