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

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 🙂

fromat v2.yxmd