Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Want to display data row wise based on header column

Surajnair
7 - Meteor

Pls find attached file data with required output

4 REPLIES 4
Raj
16 - Nebula

@Surajnair please explain the logic clearly.

Raj
16 - Nebula

@Surajnair 
is this what you are looking for?
find the workflow attached.

Surajnair
7 - Meteor

Hi Raj,

 

I want table name value in header and Concat_Value data same to be assigned against header in row wise

 

for example - 

 

CLIENT_PLAN_DOCUMENTS - should be header from tablename column and all concat value which is related to CLIENT_PLAN should be in row wise

same should be for CBA_PIN

 

 

CLIENT_PLAN_DOCUMENTS                 CBA_PIN

CLIENT_ID                                                 CLIENT_ID 
DOC_SEQ_NO                                          GLOBAL_ID
PRODUCT_ID                                            PIN
ACTIVE_FLG                                              NEW_PIN
MODIFY_USER
MODIFY_DTM
CREATE_USER
CREATE_DTM
RELEASE_FORM

 

hope this helps you get idea what im trying to achieve

Raj
16 - Nebula

@Surajnair please find the workflow attached
are you looking for something like this.
if yes this can be cleaned as per requirement.

mark done if solved.

Labels
Top Solution Authors