37394_en-US

liliconcom

Corresponding Row for a Column Minimum

I am trying to find a corresponding row for a column Minimum "DEF" and trying to do that by column "GHI"?

I am able to find the Column Minimum for "DEF" but I am not getting the corresponding row value for column "ABC"?

 

I am using the following piece of code:

 

dt = current data table();
dt<

dt<r = rmat[1];
y = :ABC[r];));

Re: Corresponding Row for a Column Minimum

Thank you that worked for my script

Re: Corresponding Row for a Column Minimum

See if this code provides you what you want

dt = Current Data Table();
dt << New Column( "BestB", numeric, continuous, Format( "Best" ), Formula( Col Minimum( :DEF, :GHI ) ) );
dt << New Column( "BestO",
 numeric,
 continuous,
 Format( "Best" ),
 Formula(
  dt=current data table();
  GHIValue = :GHI;
  :ABC[(dt<<GET rows="" where=""></GET>