Auto Insert Rows in PowerQuery to a Table

QTHUYNH

New Member
Joined
Aug 31, 2017
Messages
7
Any know how to auto insert a row in a table based off of set criteria? I have two tables I'm working with.

1st Table is the main output table with part number, price, dates, po #, vendor name.
2nd Table is a list of part numbers and licensing fees per unit per part number.

Right now everything is done manually via IFs and VLookups in excel.

In the current state, the row in red is manually inserted if the IF and Vlookup formula in the "Licensing Fee" column is "Yes".

The main driver is Part Number. All other info in the RED row was copied from the row above it except for the Price/Unit.

I want to be able to replicate and automate this manual process in Power Query. Example below.



Example
DateVendorPart NumberPO #QtyPrice / UnitTotalLicensing Fee
1/10/99WylieZYX-112344100100$10,000No
1/11/99ACMEXYZ-112345100125$12,500Yes
1/11/99ACMEXYZ-11234525$(2,500)

<tbody>
</tbody>
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
What I would do is this

1 set the original table to “do not load”
2 create a reference to this table and filter for the event where a new record is required.
3 make changes to the table in 2 so it has the records you want
4 append table from 3 to 1
 
Upvote 0

Forum statistics

Threads
1,213,522
Messages
6,114,112
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top