This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
hi, i am new to Alteryx and i am trying to sort data from pic 1 to pic 2 which means when 1 amount of favourite is higher than the another one and they fall under the same Child, it will considered as the only favourite, a new column is created/existing column will be updated to become pic 2
sorry i forgot to include another column that contains different data. below is the new column appended and the new output that i am looking for. any #N/A value when be compared to others, it will display the other value instead of #N/A even though #N/A is higher. please refer to pic 3 as the existing table and pic 4 the new output.