Macro for Power Query? (adding column)

Hello there,

I wonder if the following is possible. I have a file with over 14 million rows. It is a raw CSV file that can be easily handled using Power Query.

However, I need to analyze some information that is only available by comparing some row cells to an independent file I have with the desired information to analyze. For example:

Party Code	Party
001	A name
002	Another
001	A name
152	Here
132	Random

And I need to analyze them depending on whether the party is X, Y or Z ... Information available in an independent file. It looks like this:

Party Code	Type
001	coalition
002	Other
001	coalition
152	alone
132	other

The expected result within the power query:

Party Code	Party	Is coalition	Others	Is Party alone
001	A name	coalition
002	Another		Other
001	A name	coalition
152	Here			alone
132	Random		other

That way I can easily filter them out by the type of Party.
Therefore, I was wondering if there is any way to create a macro that adds new columns to the power query based on that independent file.