Filling the Delivery Date of Missing Rows for the Same Orders

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.

Parse

Accepted answers

JosephSerpis

Hi @OErdinc if you reorder your data you can fill in the missing dates. I've attached an example to showcase such an approach.

Delivery_Dates_29112021.yxmd

All comments

JosephSerpis

Hi @OErdinc if you reorder your data you can fill in the missing dates. I've attached an example to showcase such an approach.

Delivery_Dates_29112021.yxmd

chuckleswk

Please see the attached workflow that will use a filter to identify the transaction type of Statis and then a join that will match your order numbers back with the original data and a formula to update the delivery date.

Deliver Date.yxmd

OErdinc

Those worked like magic! Many thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703