Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 2 Excel files with one table each.
One table contains data with >500 rows and specific columns.
There are blank values in one importanct column for me in this table which need to be filled.
I have another Excel file with a table that contains the missing data / blanks of the first table.
This second table has the identical structure as the first table but only with the data that is incomplete in table 1.
Can I merge / append the two table so that I have the structure and rows of table 1 but filled with the missing data that comes from table 2?
Thank you
Sample file:
table 1:
table 2:
Solved! Go to Solution.
Hi @deboec ,
As far as I understand, you need to get Project column value and it can be looked up by Id column.
1. Merge queries in your first table, use Id columns in both tables, Left Outer join kind.
2. Enpand the needed column (Project).
3. Does your second table contain ONLY missing values from the first one?
If so, you can Merge these columns (choose 2 columns: initial Project column & merged Project column), click Transfrom > Merge Columns.
If not, click Add Column > Custom Column and
if [Project] = "" then [T2.Project] else [Project]
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
Hi @deboec ,
As far as I understand, you need to get Project column value and it can be looked up by Id column.
1. Merge queries in your first table, use Id columns in both tables, Left Outer join kind.
2. Enpand the needed column (Project).
3. Does your second table contain ONLY missing values from the first one?
If so, you can Merge these columns (choose 2 columns: initial Project column & merged Project column), click Transfrom > Merge Columns.
If not, click Add Column > Custom Column and
if [Project] = "" then [T2.Project] else [Project]
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!