I have data input in multiple columns where I want to reformat to show only the data i need.
Below i have the data currently being input and what I would like to see after i do some formulas but I'm not sure how to get to my desired outcome.
I need the accept and reject dates but I need the deliver type created by person/
This is what is currently being input | ||||||
Accept/Reject Date | Transaction Date | Item | Qty | Location | Created by | Type |
6/11/2019 | 6/12/2019 | ABC | 100 | Review | 1 | Accept |
6/12/2019 | 6/12/2019 | ABC | 100 | Review | 2 | Deliver |
6/3/2019 | 6/3/2019 | EFG | 500 | Over | 3 | Reject |
6/3/2019 | 6/3/2019 | EFG | 500 | Over | 4 | Deliver |
This is what I want output | ||||||
Accept/Reject Date | Transaction Date | Item | Qty | Location | Created by | Type |
6/11/2019 | 6/12/2019 | ABC | 100 | Review | 2 | Accept |
6/3/2019 | 6/3/2019 | EFG | 500 | Over | 4 | Reject |
Solved! Go to Solution.
Hello @ashleyinman ,
Hope this helps.
Results are shown in the join tool
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards
Hi @ashleyinman ,
In order to filter out these rows of data, what you could do is use a Filter tool. In the Filter tool you will design an expression that looks for when the "Type" column equals "accept" or "reject". The expression will look like this:
[TYPE] = "Accept" OR [TYPE] = "Reject"
I hope this helps!
Best,
Hi @ashleyinman ,
Attached is my solution, see if that works for your specific problem.
Best,
Fernando Vizcaino