Forum Discussion

evilmen's avatar
evilmen
Frequent Visitor
3 years ago
Solved

new table based on 2 tables

Good morning, could you help me? I have 2 tables, each with multiple fields. I am trying to get fields from the 2 tables and form a new one.   tables      new table    
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  evilmen ,

     

    Here are the steps you can follow：

    1. In Power Query – Merge Queries -- Merge Queries as New.

    Table usuarios

    Table empresa

    The two tables are linked together with [nit empresa].

    Join Kind:Left Outer

    2. Extend [table empresa] – check [nit empress].

    3. Select [saldo],[nit empresa] – Remove Columns.

    4. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  evilmen ,

 

Here are the steps you can follow：

1. In Power Query – Merge Queries -- Merge Queries as New.

Table usuarios

Table empresa

The two tables are linked together with [nit empresa].

Join Kind:Left Outer

2. Extend [table empresa] – check [nit empress].

3. Select [saldo],[nit empresa] – Remove Columns.

4. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly