Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

how to pick last value from each column

kauser
8 - Asteroid

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

 

ABC
509065
805532
503065

 

Thank you 

 

kauser 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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

WeiLi
7 - Meteor

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.

Labels