Reduce data

[gidon]

Hello

when I load a table I want to reduce Part Numbers

according to falg given on differnt table

this ia my data  and reduce flag table

I want to load only parts with Reduce = 'n'

( this table is only a sample my tables includes millions of data lines , and about 50000  part

thanks

gidon

this is the flag table

part	Reduce
100	n
200	y
300	n
400	y

this is tha data table   

part	cust	Quant	UnitP	CUR
100	1	1000	500	10/10/15
200	3	5500	600	11/11/14
300	6	7000	700	12/12/15
200	7	15000	800	03/15/13
100	8	9000	400	03/12/11
200	9	9000	300	03/12/09
300	1	9000	200	03/12/07
400	3	9000	250	08/15/12
100	6	9000	500	07/07/17

[Greg_Deckler]

So, you need to do a Merge Table step in your main query where you merge your two tables. Then, you can easily filter out the "Reduce = 'n'" rows by selecting the dropdown for that column and unselecting everything by "n".

[gidon]

hi

thanks for your fast response

how do i Merge those two tables

thanks

gidon

[Greg_Deckler · Accepted solution]

In Power Query editor (Edit Queries), select your main query. Go to the last step in that query. All the way to the right you should see "Merge Queries". Click that. It will bring up a dialog allowing you to select the common columns and pick what kind of join you want.

[gidon]

will try and advice

thanks

gidon

[gidon]

thank you very much

gidon

[Greg_Deckler]

No problem! Glad it met your need!