Subset with added formula column - almost there

wendy1123

I am trying to create a script to subset data which also adds a column with a formula in it. I am close (sort of). I can create the subset, with the new column, but the new column only has dots in it. 

Here is what I have so far:

Data Table( "Melt Curve Raw Data" ) << Subset(
	By( :Well Position ),
	All rows,
	Selected columns only( 0 ),
	columns( :Temperature, :Fluorescence,  New Column( "Normalized Fluorescence", formula(
	(:Fluorescence - Col Min(:Fluorescence )) / (Col Max(:Fluorescence )
	-Col Min(:Fluorescence )))
	))
	);

After searching, I saw something about an eval command, but as a beginner I can't figure out how to add it in so it works.

**Ideally I would also be able to add the new column directly after the Temperature column instead of at the end

Thank you in advance for any advice!!

txnelson

Here are 2 solutions to the issue.  The first one changes the calculation to use the min and max values for the particular Well Position that is being evaluated.

Data Table( "Melt Curve Raw Data" ) << New Column( "Normalized Fluorescence",
	formula(
		(:Fluorescence - Col Min( :Fluorescence, :Well Position )) / (
		Col Max( :Fluorescence, :Well Position )
		-Col Min( :Fluorescence, :Well Position ))
	)
);
	
Data Table( "Melt Curve Raw Data" ) << Subset(
	By( :Well Position ),
	All rows,
	Selected columns only( 0 ),
	columns( :Temperature, :Fluorescence, :Normalized Fluorescence )
);
	
Data Table( "Melt Curve Raw Data" ) << delete columns( :Normalized Fluorescence );

The second one creates the subsetted data tables, and then goes back and add the new column for each of the new data tables produced

new tables = Data Table( "Melt Curve Raw Data" ) <<
Subset(
	By( :Well Position ),
	All rows,
	Selected columns only( 0 ),
	columns( :Temperature, :Fluorescence, :Normalized Fluorescence )
);
	
For( i = 1, i <= N Items( new tables ), i++,
	new tables[i] << New Column( "Normalized Fluorescence",
		formula(
			(:Fluorescence - Col Min( :Fluorescence, :Well Position )) / (
			Col Max( :Fluorescence, :Well Position )
			-Col Min( :Fluorescence, :Well Position ))
		)
	)
);