topic Re: I need to compare several columns in Discussions

I need to compare several columns

gallardet — Mon, 08 Jul 2019 16:47:14 GMT

Hi.

I have a table with several columns with values that represent total votes obtained by political parties. I need a script that finds the greatest values of these columns and obtains the name of the column, i.e. the political party.

Thanks in advance for your help.

Manel

Re: I need to compare several columns

Jeff_Perkinson — Mon, 08 Jul 2019 17:02:59 GMT

You can do this with the Formula Editor.

Use the Maximum() function to find the max value in the columns and then the Match() function to match it to which column it came from.

The attached data table has the example.

Re: I need to compare several columns

gallardet — Mon, 08 Jul 2019 17:49:54 GMT

Thanks a lot Jeff,

I have a question.

How to do the second part of the formula?

Re: I need to compare several columns

Jeff_Perkinson — Mon, 08 Jul 2019 18:51:01 GMT

The Match() function is under the Conditionals section of the Formula Editor.

With the Maximum() funtion built and selected in the Editor, click on Conditionals -> Match. You'll be prompted about adding arguments, select "Do Not Add".

Then click on the ^ button in the toolbar to add the four pairs of arguments and then fill them in.

Re: I need to compare several columns

WebDesignesCrow — Mon, 22 Aug 2022 10:21:55 GMT

In script form :

dt << New Column( "Maximum",
		Character,
		"Nominal",
		Formula(
			Match(
					Maximum(
						:Party A,
						:Party B,
						:Party C,
						:Party D
					),
				:Party A, "Party A",
				:Party B, "Party B",
				:Party C, "Party C",
				:Party D, "Party D"
			)
		));