Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Updating data with Column names

Niru
8 - Asteroid

Hello All,

 

kindly help me to get below mentioned output.

INput:

IDCCB_MARKETING_AND_COMMCCB_OPERATIONSUS_PBUS_WMWM__Detail_Deck_Only_
115563 115563115563  
115564 115564 115564115564

 

Expected Output:

IDCCB_MARKETING_AND_COMMCCB_OPERATIONSUS_PBUS_WMUS_WM
115563 CCB_OPERATIONSUS_PB  
115564 CCB_OPERATIONS US_WMUS_WM

Thanks & Regards,

Niru

 

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @Niru,


In the last column, you need to rename yourself as I didn't saw any pattern to it. The solution is replicating the column name if the position isn't empty. 

 

I think this solution should be sufficient for you.

 

Emil_Kos_0-1613474134390.png

 

 

The output:

 

Emil_Kos_1-1613474177256.png

 

AngelosPachis
16 - Nebula

Hi @Niru ,

 

Maybe this would work?

 

AngelosPachis_0-1613474201124.png

 

Labels