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
Solved! Go to Solution.
Hi @kauser can you use a sample tool with it set to "Last N Rows" then set N to 1?
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.