Free Trial

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

transforming

JASON_OJS
5 - Atom

HI, I have question in data transformation (dynamic no hard code) and pls help!!!!! 

 

 

1 REPLY 1
shancmiralles
11 - Bolide

hi!
i think this is doable if your final output's columns/fields remains the same.. so if there are additional data needed then it is only going to be added by record/row  on your data input file :


 

:TextInput:-> :Transpose:-> :filter: (T) -> :Summarize: -> :Sort: -> :TextToCols: -> :Select:---- >  

                    (F) -> :Summarize: -> :Sort: ------------------- ->    :Join:  ->  :TextToCols: -> :Sort: -> :RecordID: -> :Select: