Hello,
My name is Pawan. I am new to Alteryx. I working on my data set and got stuck. This may be a simple one but I am not able to figure out. I have data something like this
Item | Date | Batch |
1 | 11.09.2019 | qwerty12 |
1 | 12.09.2019 | uioplk23 |
2 | 11.09.2019 | ghjuyu |
3 | 13.09.2019 | dhhfyu |
3 | 15.09.2019 | cnmdke |
4 | 14.09.2019 | shshkjke |
4 | 16.09.2019 | dvnjdl |
Now, if I want the "Item" with the minimum "Date" along with respective "Batch", how can I do it. So ideally I should have one Item, Date, Batch Combined. Please help me.
Thank you all in advance.
Solved! Go to Solution.
Hi @PawanTeza the attached workflow produces the output you describe. Let me know what you think?
Thank you for quick reply. But what I am trying to achieve is something like this.
Item | Date | Batch |
1 | 11.09.2019 | qwerty12 |
2 | 11.09.2019 | ghjuyu |
3 | 13.09.2019 | dhhfyu |
4 | 14.09.2019 | shshkjke |
In case of Items 1,3,4 there are double dates with double batches. I would like to get only the batch with minimum or nearest date. In case of Item 2, as there is only one entry I want it as it is.
Please let me know if this possible.
Thank you!
Hi @PawanTeza you can do that in two ways have attached a workflow which showcases this.
Thank you. That helps