Forum Discussion
join 2 different tables
Hi jppuam
Full outer will merge rows from both TableA and Table B (matching or not matching).
For example:
Table A has dates 2021/01/01 - 2021/01/03.
Table B has date 2021/01/04.
If you use Full outer to merge two tables, result is as below.
Here is a blog about join kind in Merge in Power Query.
For reference: Choose the Right Merge Join Type in Power BI
If you want to expand all values in Table B for each Row in Table A, you can try to add custom column.
Expand rows you need from Table B.
Best Regards,Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks RicoZhou,
just one question, if i've in table A (some dates - not every days) and on table B other dates (for example like you put - Table B with record on day 4) than i should use full outer join right ?
thanks,
JP
Hi jppuam
Full outer will merge rows from both TableA and Table B (matching or not matching).
For example:
Table A has dates 2021/01/01 - 2021/01/03.
Table B has date 2021/01/04.
If you use Full outer to merge two tables, result is as below.
Here is a blog about join kind in Merge in Power Query.
For reference: Choose the Right Merge Join Type in Power BI
If you want to expand all values in Table B for each Row in Table A, you can try to add custom column.
Expand rows you need from Table B.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.