Formatting of the data

Question

Hi,

i have a situation were i dont need data in some fields when the customer and receiver both are same and they should get filled when one among them changes in the data.

I am attaching the current and required format template.

Can anyone help how this can be done in Alteryx

Alteryx Test.xlsx

JosephSerpis · Accepted Answer

Hi @bnari12 I mocked up a workflow with a couple of ways to approach this. Let me know what you think?

Emil_Kos · Accepted Answer

Hi @JosephSerpis,

That was good. I wanted to use a combination of multi row formula + transpose tool to make relevant positions blank but your solution is faster and require less formulas 🙂

bnari12 · Accepted Answer

Wow ! Thats amazing and you are a true champion.

Thank you so much ..

cheers..