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,
I don't know if you have already closed your question, but I would like to know why it was unclear what rule you set to fetch <1 mile. Values below 1 mile are only found in comparisons of other lines.
If it is open you could describe a little more of this rule
Hi @smfhsan2005 ,
Can you clarify "< 1 miles from B" ? B is a number . Distances can be calculated between 2 points .
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%
Name | Lat | Long | A | B | C | D | E |
ML03109 | 43.090194 | -87.965972 | 84.26 | 96.45 | 98.79 | ML60161 |
Is ML60161 expected result ? It is not < 1 mile from ML03109.
1st case and 2nd Case : Are these columns D and E i.e outputs ?
The attached wf calculates nearest point for all points and they all are > 1 mile .
You can revise algorithm to make it more easy for community to provide expected results .
hi,
I worked out a workflow maybe it can be a little complicated. Includes 4 rule-based possibilities:
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.
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.
Yes D and E are outputs.
Cascade | Latitude | Longitude | A | B | C | B>A | C>B |
ML03109 | 43.090194 | -87.965972 | 84.26 | 96.45 | 98.79 | Jump to ML03111 or cascade nearest to ML03109 but less than 90% | Here just the formula is ok since there are no values less than 90% |
This helped me a lot..thanks benakesh.
Hello All,
Thanks for your help in my previous task, here I have another task with additional requirement, I am stuck at the formula where I need to find the column with greater than 80% value(Which I have already done it) and jump to the value less than 60% in the same column within 3 miles of radius.
Column H is the output where you see if Column High Y to Low Y and there is no jump since the value is less than 80% but when you see the Row7 has 92.22 value jumped from 03RW300-1 to 03RW300-2 and this value is on the same location (lat long are same), here I need the out should be little away from that exact location which has different row value which is less than 60% within 3 miles of radius.
just an example eg..RW300-1 to 03RW312-1 which is 4.06 and within 3 miles of 03RW3001-1
Please help.
Hello All,
Sorry forgot to attache the tool and input..
Thanks for your help in my previous task, here I have another task with additional requirement, I am stuck at the formula where I need to find the column with greater than 80% value(Which I have already done it) and jump to the value less than 60% in the same column within 3 miles of radius.
Column H is the output where you see if Column High Y to Low Y and there is no jump since the value is less than 80% but when you see the Row7 has 92.22 value jumped from 03RW300-1 to 03RW300-2 and this value is on the same location (lat long are same), here I need the out should be little away from that exact location which has different row value which is less than 60% within 3 miles of radius.
just an example eg..RW300-1 to 03RW312-1 which is 4.06 and within 3 miles of 03RW3001-1
Please help.
Hi @smfhsan2005 ,
Some input files are not shared . Can you attach all input files ?
I am stuck at the formula : There are 3 formula tools in wf . Which formula is not working ?
Also sample input data and expected output data can help .
Hi @benakesh please find attached input.
@benakesh Need to update in all formulas..
Input and output I attached to my previous message, please let me know if you could get it.