I believe I have seen this in a video, but I couldn't find it again, or anything that addressed it on these forums. I'm new to Power Query.
Using Power Query, I have created a table (Table 1) from 8 workbooks. There is a second table created from the second set of workbooks (Table 2) that shares a common field with Table 1 named "ACC#". Table 2 has an additional field/column "Details" not found in Table 1. I would like to add and align the "Details" field/column from Table 2 to Table 1 based on the common field "ACC". How would I "bring in" the"Details" from Table 2 and align them to the correct ACC# on Table 1?
Using Power Query, I have created a table (Table 1) from 8 workbooks. There is a second table created from the second set of workbooks (Table 2) that shares a common field with Table 1 named "ACC#". Table 2 has an additional field/column "Details" not found in Table 1. I would like to add and align the "Details" field/column from Table 2 to Table 1 based on the common field "ACC". How would I "bring in" the"Details" from Table 2 and align them to the correct ACC# on Table 1?