Referencing to a specific data table

ENTHU

Hi,

 

I have a data table dtValues.I have sorted the data table as follows -

dtValues << Sort(
By( :test_end_date_1 ),
Order( Ascending ),
Output Table( "out_sorted" )
);

 

Now I want to get unique values from a column "weight" from the out_sorted table.

I tried the following code -

unique_wt = {};
unique_wt = Associative Array( dtValues:weight ) << Get Keys

But this code gives unique values from the table before sorting.I am looking for weight values from the sorted table.

How do I get around this?

 

 

txnelson

You need to set a pointer to the new data table that is being created.  The below code does that:

dtSorted = dtValues << Sort(
	By( :test_end_date_1 ),
	Order( Ascending ),
	Output Table( "out_sorted" )
);
 

unique_wt = {};
unique_wt = Associative Array( dtSorted:weight ) << Get Keys;