Row Comparison

[nkumarjha]

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

[Ladarthure]

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!

[JordanB · Accepted solution]

Hi @nkumarjha

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

[nkumarjha · Accepted solution]

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

[nkumarjha]

Hi Ladarthur, thanks for your help. 

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

Regards

Nk

[Ladarthure]

@nkumarjha could you send me the workflow so that I give a look?

[nkumarjha]

@Ladarthur workflow attached. 

[Ladarthure · Accepted solution]

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

[nkumarjha]

Ladarthur its working now thanks a lot