Hi all,
I have a transaction based e-commerce platform report. For some of the transactions, [Delivery date] info is missing and my purpose is to fill them for each order.
As you can see from the below image, we have the [Delivery date] except for the bottom row. I could easily do this with multi-row formula but this is not the only case; so that my multi-row approach does not work for each order. Please consider the Example 2
Example 1
In this example, we have 4 null [Delivery Date] for [Order No] = 83538850
Example 2
I noticed that each Order No has a [Delivery Date] when the [Transansaction Type] is "Satış". So I am looking for a way to tell Alteryx below but I couldn't figured it out how to do this indeed with tools:
If [Delivery Date] is missing, return the [Delivery date] of Satış [Transaction type = Satış] for the same [Order No].
I need to solve this urgently. I would deeply appreciate any help.
Solved! Go to Solution.
Hi @OErdinc if you reorder your data you can fill in the missing dates. I've attached an example to showcase such an approach.
Those worked like magic! Many thanks!