Transform Header with Dynamic name

[Harsh-Goyal]

Hi Community,

I am trying to solve the following pattern update but not success yet..

Can someone help 

[atcodedog05 · Accepted solution]

Hi @Harsh-Goyal 

Here is workflow on how we can get the expected output.

In brief

1. In the first branch i am transposing and finding the order of occurrence of company and assigning them group ID (field that needs to be filled)

2. In 2nd branch i am transposing and creating/starting a group id for every occurrence of "TC" (this marks the start of group)

3. Joining company & entity using group ID

4. In 3rd branch i am transposing the data.

5. Joining data with company & entity using column ID (Alteryx auto generated)

Hope this helps 🙂

[Harsh-Goyal]

It worked similarly to my logic and generated exactly the same results.

But yes it's short and sweet 👏

Was my initial logic helpful to give you a new perspective?

Cheers Mate!

Best,

Harsh

[atcodedog05]

Hi @Harsh-Goyal 

Yes your steps was helpful in figuring out the logic 🙂

Hope it helped you 😀

Have a nice day 🙂