Forum Discussion

nzaccountant's avatar
nzaccountant
Frequent Visitor
5 years ago
Solved

M Code to extract IO number

hi there I have a list of Machinery Items with Internal order (IO) Numbers.  I then have a list of transactions with the IO number contained in it.    I would like to write some sort of M code wh...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  nzaccountant ,

    Here are the steps you can follow：

    1. Select add column - index column - from 1 in the power query to add indexes for both tables.

    2. Select Home-Merge Queries-Merge Queries, merge the two tables using left Outer according to [Index],

    3. Select Add column – Custom column

    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
5 years ago

Hi  nzaccountant ,

Here are the steps you can follow：

1. Select add column - index column - from 1 in the power query to add indexes for both tables.

2. Select Home-Merge Queries-Merge Queries, merge the two tables using left Outer according to [Index],

3. Select Add column – Custom column

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.