Row Comparison

Hi

I am new to Alteryx and i am trying to use it for a row comparison scenario,

if Part Number (row 1)=part number(row 2) then Min(Prices Quoted). it needs to work for all the duplicate Part numbers.

Thanks a lot for helping

ID	Part Number	Prices Quoted	Prices.MOQ	Supplier Name
1	210-069891	0.288	3000	ABCD
2	210-069891	0.53875	3000	DEF
1	240-023480	0.57	3000	gfdc
2	240-023480	0.6	3000	bdls
1	240-077762	22.5	500	hdsa
2	240-077762	26	360	dshd
1	310-035669	1.9	1000	dscf
2	310-035669	1.9	1000	nfsd
1	310-051923	1.9	1000	bfds
2	310-051923	1.9	1000	fghh
1	430-046761	64.5	500	wfehg
2	430-046761	53	500	afgewg
1	430-046762	50	500	wgwh
2	430-046762	57.2	500	sgwea
1	430-046763	58.5	500	aghah
2	430-046763	55	500	whakh

Price Comp.xlsx

Data Investigation

Accepted answers

The easiest way would be to use a summarize tool and Join.

The summarize tool can find the minimum for each part number and then you can simply use a join tool to add this field to your master dataset.

Workflow attached

Best,

Jordan

Thanks a lot Jordan, I was able to get to end result.

Here it is, you needed a space between if and the variable name, I just modified a bit the formula to work

New Workflow2.yxmd

All comments

Hi,

to do so you could use a multi row formula tool and the formula should be something like this :

if [Row-1:Part Number] = [Part Number] then min([Row-1:Prices Quoted],[Prices Quoted])
else null() endif

it gives you the minimum price then you can filter the null values

Or you could simply use a summarize tool, do a group by on part number and a min on Prices Quoted.

Hope it helped!

The easiest way would be to use a summarize tool and Join.

The summarize tool can find the minimum for each part number and then you can simply use a join tool to add this field to your master dataset.

Workflow attached

Best,

Jordan

Thanks a lot Jordan, I was able to get to end result.

Hi Ladarthur, thanks for your help.

I did use the multi row function but the expression is giving an error.

Regards

Nk

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703