how to pick last value from each column

[kauser]

Hi i need help on how to pick last balance from each column. Such as i need to pick these values from each column A- 50, B- 30,C-65

A	B	C
50	90	65
80	55	32
50	30	65

Thank you 

kauser 

[JosephSerpis]

Hi @kauser can you use a sample tool with it set to "Last N Rows" then set N to 1?

[WeiLi · Accepted solution]

another alternative is to assign RecordID, then sort it by reverse order, then use Select Record to select the 1st.

you might be wondering.... who in their right mind would do this... well if you have AMP turned on, it sometimes mess up the ordering of the output, so that RecordID becomes necessary to restore stuff in their intended order.