Formatting of the data

[bnari12]

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

[JosephSerpis · Accepted solution]

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

[Emil_Kos · Accepted solution]

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 solution]

Wow ! Thats amazing and you are a true champion. 

Thank you so much ..

cheers..