Formula for Output columns

[ashleyinman]

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

[afv2688 · Accepted 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

[ConnorK]

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,

[fmvizcaino · Accepted solution]

Hi @ashleyinman ,

Attached is my solution, see if that works for your specific problem.

Best,

Fernando Vizcaino