Forum Discussion
Help with Formula in Power Query - IF(ISNA(VLOOKUP
Hi,
I apologize that I wasn't able to get to this quicker but it wouldn't allow me to share a screenshot earlier.
I have a newer issue that I need to solve before moving from the original one.
- I have the table below that is under my "Merge2". I have my common key of "App Login" that os the same on each of the queries. My second query is "Merge 4" and that contains the same columns, same column headers but I need to add those 30 rows to the "merge2" query but when I go to do that (appending the queries), it creates additional columns versus the added rows with that information filled into the columns that are already there.
- Before moving to power query, we would take these two tabs and then use am index/match formula as follows:
=INDEX(PIC!G:G,MATCH('VFID Map'!C:C,PIC!B:B,0))- PICG:G is the app login column in my screenshot below (Merge2)
- VFID Map column is the App Login in my Merge4
- I need to pull in 5 different columns into the respective columns in my Merge2 query
Is there a way to do this? I apologize if I am not explaining it too well but I just started using Power Query a week ago and still learning.
Thank you very much in advance and please let me know if you need anything else or if I messed up providing the explanation.
Thank you,
Brooke
Hello blfox4
if you need to add rows, use Table.Combine. As you were stating that you already did that, but new columns where created even you have exactly the same columns, then there might be a slighlty difference in the column names (Power query is case sensitive.. so you might check if they are really exactly the same... sometimes you also might have spaces after the name.
Check it out and let us know
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy