Alteryx Designer Desktop Discussions

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

Transform Table

AQIL-KURJI
5 - Atom

Hello all, 

I am trying to transform my data in a certain way but I am not sure what tools would be appropriate for this?

 

Initial Table: 

 

AQIL-KURJI_0-1607648416194.png

Final Table: 

 

AQIL-KURJI_1-1607648452027.png

 

Any idea as to how i can transform this? I tried summarize and it would only get me the first and last filepaths. 

 

Thanks

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@AQIL-KURJI 
Something like should help.

1211-AQIL-KURJI.PNG

Labels