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