Hello Experts, I am new to Alteryx, I have a tasks of comparing two columns and return with the 3rd column vaue which has the lowest of the value..any help will be highly appreciated.
eg..If Column B2 >90% in this case(96.45) is greater than A2(84.26) then jump to value of column B which has less than90% in this case B3 and return value from Colum A ML60161 and if Column B already less than 90% then return Same name as Column Name.
Name | A | B | End result |
ML03109 | 84.26 | 96.45 | ML60161 |
ML60161 | 76.41 | 88.42 | ML60161 |
ML03110 | 80.24 | 93.42 | ML03121 |
ML54755 | 66.29 | 96.33 | ML03152 |
ML17103 | 56.33 | 95.02 | ML03121 |
ML03121 | 29.81 | 83.58 | ML03121 |
ML03152 | 45.52 | 73.03 | ML03152 |
ML13107 | 41.39 | 81.55 | ML13107 |
ML03111 | 40.02 | 84.83 | ML03111 |
Solved! Go to Solution.
Hi,
This table has a certain number of rows or is it dynamically increasing regularly
[]
For now its only few rows, but it will increase dynamically.
4th row should show the name from column "name" related to the value which has less than 90% of column B.
Row 6 col B value ( 83.58) is < 90 % . Your results shows row 7 value . Is there a reason you skip row 6 and pick
row 7 ?
Hello @benakesh. thanks it helped me 90% as per your genuine question yes.the second part of this task is checking the distance between 2 names in Column "name" which is nearest one to each other will become the criteria for 4th column. here we can consider atleast within 2 miles.
Cascade | Latitude | Longitude | A | B | C | Endresult |
ML03109 | 43.090194 | -87.965972 | 84.26 | 96.45 | 98.79 | ML60161 |
ML03110 | 43.07121 | -87.95345 | 80.24 | 93.42 | 98.61 | ML60161 |
ML03111 | 43.11725 | -87.93044 | 40.02 | 84.83 | 96.06 | ML03121 |
ML03121 | 43.07941 | -88.0043 | 29.81 | 83.58 | 94.96 | ML03152 |
ML03152 | 43.08595 | -87.925217 | 45.52 | 73.03 | 98.87 | ML03121 |
ML13107 | 43.09686 | -87.98471 | 41.39 | 81.55 | 94.64 | ML03121 |
ML17103 | 43.115014 | -87.964947 | 56.33 | 95.02 | 98.55 | ML03152 |
ML54755 | 43.074108 | -87.976078 | 66.29 | 96.33 | 96.3 | ML13107 |
ML60161 | 43.098492 | -87.94245 | 76.41 | 88.42 | 97.26 | ML03111 |
No there is no particular reason behind it..it should be in sequence which has less than 90%.
I am really sorry for not able to communicate exactly but my complete task is like below...I
Here is the Algorithm:
1st case : if B value is >90% and also >A then D should have the Name which is < 1 miles from B. in continuation to this scenario we have
2nd case: if C value is >90% and also >B then E should have the Name which is < 1 miles from C but in this case C and B are mostly >90% but I need the formula for it in future use.
Note: It will be ok if the names been repeated within 1 mile.
Name | Lat | Long | A | B | C | D | E |
ML03109 | 43.090194 | -87.965972 | 84.26 | 96.45 | 98.79 | ML60161 | |
ML60161 | 43.098492 | -87.94245 | 76.41 | 88.42 | 97.26 | ML60161 | |
ML03110 | 43.07121 | -87.95345 | 80.24 | 93.42 | 98.61 | ML03121 | |
ML54755 | 43.074108 | -87.976078 | 66.29 | 96.33 | 96.3 | ML03152 | |
ML17103 | 43.115014 | -87.964947 | 56.33 | 95.02 | 98.55 | ML03121 | |
ML03121 | 43.07941 | -88.0043 | 29.81 | 83.58 | 94.96 | ML03121 | |
ML03152 | 43.08595 | -87.925217 | 45.52 | 73.03 | 98.87 | ML03152 | |
ML13107 | 43.09686 | -87.98471 | 41.39 | 81.55 | 94.64 | ML13107 | |
ML03111 | 43.11725 | -87.93044 | 40.02 | 84.83 | 96.06 | ML03111 |
Thanks Gerarldo. this helps but unable to get it with nearest location.