none
How to add vlookup column in power query RRS feed

  • Question

  • Hello. I've learned how I can use power query to update multiple csv files in a folder into a table. The only thing is that I want to add 1 column that references a table for a vlookup. Is there any way to do this in powerquery so that it's done each time I update the csv files? Thanks. 
    Wednesday, February 8, 2017 5:55 PM

Answers

  • There is no VLOOKUP. But you can load the second table and do a merge "merge table" using the common key column. Then expend he column you need.

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Thursday, February 9, 2017 10:17 AM