Splitting full file path into small its it is original components

[mkhaled]

Hi All, 

I have a filed contains list of full file names and want to split into rows on one filed as follows

input

C:\ABC\123.txt

C\AAA\yyy\xcn.pdf

needed output

C:\

C:\ABC\

C:\ABC\123.txt

C\

C\AAA\

C\AAA\yyy\

C\AAA\yyy\xcn.pdf

is there is anyway to do that with Alteryx

[JohnJPS · Accepted solution]

I would use Text to Columns to split these to rows based on the slash, and follow that with a MultiRow formula with something like:

if [field] == "C:" then
[field] + "\"
else
[Row-1:field] + [field] + "\"
endif

Hope that helps!
John

[RolandSchubert · Accepted solution]

Hi,

SplitToCloumns and Multi-Row-formula do the job - see attached workflow.

Best regards

Roland

[mkhaled]

@JohnJPS and @RolandSchubert  I tested the solution and it is working fine. Thanks for your help.

[MarqueeCrew · Accepted solution]

@mkhaled,

Here is a completed workflow (following the suggestion from @JohnJPS ).  If you grant me a solve, please also grant John the same courtesy.

Cheers,

Mark