How to create a folder, if its not existing already
hi @fharper how to concatenate values in same rows till blank value is found
@vencric , you should not embed multiple problems within same thread. It becomes impossible for others to follow and to search for answers.
the info in this thread should be specific to the original issue "How to create a folder, if its not existing already".
about 2/3rds of the way through the second page of responses the discussion jumps track to a different problem with discussion around using regex and other things to determine and respond to a condition. At least it seems to be a leap to a different subject.
Also we do not see anything marked as a solution...so was your original problem of dynamically creating a folder when needed resolved and if so then please mark that reply as the answer so others with the same problem can find it.
I suggest creating a new thread for the other issue so it can be searched and a solution, assuming there is one, can be identified by others searching. you might ask one of the moderators to do this for you. I know they used to do that when they notice multiple issues in a single thread.
@vencric "how to concatenate values in same rows till blank value is found" should be title or subject of a new thread. and in regards to that clarify if this is concatenating multiple columns/fields on a row or multiple substrings within a field, which is really more a parsing question.
The statement is generic enough it could be taken either way or both which can lead to very different solutions.
Provide as much detail as possible so others who seek to help will have minimal questions and can quickly provide good ideas.
How to concatenate value in same row, till blank value is found. Ex.
Input:
Level Prefix Base Concat
0 JH 1000
1 KB 1001 KB-1001
2 BC 1002 BC-1002
1 CD 1003 CD-1003
0 AB 1004
1 AA 1005 AA-1005
Output:
Level Prefix Base Concat OP
0 JH 1000 KB-1001;BC-1002;CD-1003
1 KB 1001 KB-1001
2 BC 1002 BC-1002
1 CD 1003 CD-1003
0 AB 1004 AA-1005
1 AA 1005 AA-1005
This thread has me totally lost? It appears that rather than creating a dynamic folder name, these responses are parsing data and slinging all over the place. Can someone please walk me through something like this:
1. Period = 2022-08 (or 2022-07, 2022-09, etc.)
2. Line = L1 or L2 or L3, etc.
Current path = c:\documents\Alteryx\
I'm pulling data for August of 2022. If folder "2022-08" doesn't exist, create a folder named "2022-08".
Place files "L1" (or L2, or l3, or whatnot) into folder "2022-08".
I can get the dynamic file name to work by using the "line" field, creating one file for each Line, but since there is no folder called 2022-08, it's blowing up. I'm using a dynamic path with a formula called "Path" - 'c:\documents\alteryx\' + [period] + '\' + [line]
If the folders are pre-created it works fine with finding the correct folder and writing the correct line, it just won't create a folder.
I think you need quotes around both full paths, not only in "if not exist" command. Example: 'if not exist "' + [Directory] + 'Output\" mkdir "' + [Directory] + 'Output\"'