Achieving vlookup in POWER QUERY RRS feed

  • Question

  • I have 5 excel files.
    1. MasterDump (have 200000 records) (Say example, lookupvalue=RollNo)
    2. Child1 (1050 records)
    3. Child2 (1100 records)
    4. Child3 (20000 records)
    5. Child4 (10500 records)

    All child excel sheets contain RollNo & i want to apply MERGE operation & fetch relavant Gender from all child sheets

    - I want to maintain these 200000 records in masterdump & want to apply merge and find the relavant match for all Child excel sheets
    - If match find then i need Gender. Else let it be NULL (only first match is enough. no duplicates/increase in masterDump file)
    - MasterDump records should not be disturbed (while i am applying merge/join, duplicate records getting created in MasterDump)

    In one  word i want the exact vlookup concept need to be applied here. but i am getting duplicates & masterdump getting violated.

    Expecting your help to achieve it

    Wednesday, July 18, 2018 3:17 AM