topic Re: How to create a folder, if its not existing already in Alteryx Designer Desktop Discussions

How to create a folder, if its not existing already

vencric — Wed, 02 Mar 2022 05:45:57 GMT

How to create a folder, if its not existing already

Re: How to create a folder, if its not existing already

Qiu — Wed, 02 Mar 2022 05:56:00 GMT

@vencric
Not sure it is really an alteryx question. 😂

Re: How to create a folder, if its not existing already

vencric — Wed, 02 Mar 2022 06:14:14 GMT

Hi Qiu, Thanks for the solution,. I m facing below error

Re: How to create a folder, if its not existing already

vencric — Wed, 02 Mar 2022 06:28:11 GMT

Also the folder will vary depending on the name, coming from formula tool dynamically

Re: How to create a folder, if its not existing already

Qiu — Wed, 02 Mar 2022 08:57:42 GMT

@vencric
It did not happen to me as for the error, are running the flow from a remote location?
I am sure your have the %temp% as environment variable.
For the path, we can of course blend into the formula.

Re: How to create a folder, if its not existing already

vencric — Wed, 02 Mar 2022 09:06:52 GMT

No.. Not running from remote location and also included %TEMP%

Re: How to create a folder, if its not existing already

vencric — Thu, 03 Mar 2022 06:32:03 GMT

hi @Qiu , i am able to create folder in my local machine.... but when i'm trying to create in sharedrive, im getting this error

Re: How to create a folder, if its not existing already

Pravallika20 — Thu, 03 Mar 2022 06:57:20 GMT

Hi @vencric ,

You can drag a python tool and add the following Python code:

from ayx import Alteryx
from os import makedirs
from pandas import DataFrame
df=Alteryx.read("#1")
path=df["path"][0]

try:
makedirs(path)
except OSError:
message_log = {"MessageLog" : "Failed creation of the directory " + path,"FolderCreated" : 0,"Path":path}

else:
message_log = {
"MessageLog" : "Successfully created the directory: "+ path,"FolderCreated" : 1,"Path" :path}
output_df = DataFrame(message_log,index=[0])

Alteryx.write(output_df,1)

Re: How to create a folder, if its not existing already

vencric — Thu, 03 Mar 2022 09:09:48 GMT

Hi @Pravallika20 ... i faced error while runinng it... is it possible to create a folder in network drive

Re: How to create a folder, if its not existing already

Pravallika20 — Thu, 03 Mar 2022 11:02:36 GMT

Hi @vencric ,

You can create the folder in network drive. Can u tell me the error u are facing

Re: How to create a folder, if its not existing already

vencric — Thu, 03 Mar 2022 11:10:57 GMT

SUCCESS: reading input data "#1"

---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
   2656             try:
-> 2657                 return self._engine.get_loc(key)
   2658             except KeyError:

pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 'networkpath'

During handling of the above exception, another exception occurred:

KeyError                                  Traceback (most recent call last)
<ipython-input-2-46de07459b84> in <module>
      3 from pandas import DataFrame
      4 df=Alteryx.read("#1")
----> 5 path=df["network Path"][0]
      6 
      7 try:

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\pandas\core\frame.py in __getitem__(self, key)
   2925             if self.columns.nlevels > 1:
   2926                 return self._getitem_multilevel(key)
-> 2927             indexer = self.columns.get_loc(key)
   2928             if is_integer(indexer):
   2929                 indexer = [indexer]

c:\program files\alteryx\bin\miniconda3\envs\jupytertool_venv\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
   2657                 return self._engine.get_loc(key)
   2658             except KeyError:
-> 2659                 return self._engine.get_loc(self._maybe_cast_indexer(key))
   2660         indexer = self.get_indexer([key], method=method, tolerance=tolerance)
   2661         if indexer.ndim > 1 or indexer.size > 1:

pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 'NetworkPath'

Re: How to create a folder, if its not existing already

Pravallika20 — Thu, 03 Mar 2022 11:25:54 GMT

send me your workflow

Re: How to create a folder, if its not existing already

vencric — Thu, 03 Mar 2022 13:18:20 GMT

Hi @Pravallika20 .. i have attached sample workflow... i have given dummy value for path

Re: How to create a folder, if its not existing already

Pravallika20 — Thu, 03 Mar 2022 13:30:10 GMT

Hi @vencric ,

You need to give the exact column name in the last line in the python code i.e path= df["Field1"][0]. Since it is Field1 in the workflow you have sent, it should be the same

Re: How to create a folder, if its not existing already

vencric — Fri, 04 Mar 2022 06:37:06 GMT

hi @Pravallika20 .. what details should that column contain

Re: How to create a folder, if its not existing already

Pravallika20 — Fri, 04 Mar 2022 09:54:34 GMT

Hi @vencric

The path which you want is enough

Re: How to create a folder, if its not existing already

vencric — Fri, 04 Mar 2022 11:23:38 GMT

Actually i passed the path only, just for uploading purpose i made it a dummy variable

Re: How to create a folder, if its not existing already

vencric — Mon, 28 Mar 2022 10:59:19 GMT

Hi @atcodedog05 , how to check if 5C, is present in LC5A.. if i use REGEX_Countmatches, it showing true, because it has C5, instead

Re: How to create a folder, if its not existing already

atcodedog05 — Mon, 28 Mar 2022 11:13:24 GMT

Hi @vencric

You can use contains function like Contains([Field1], "5C"). And can you share your regex function as far I know regex should also work might need some tweaking.

Hope this helps : )

Re: How to create a folder, if its not existing already

vencric — Mon, 28 Mar 2022 11:20:40 GMT

Hi @atcodedog05 this is the function i used..

REGEX_CountMatches([Part Prefix], "B5|1M|C5|2C|3U|Z8|Z9|J9|K9
").. part prefix is the column where it wil have many words, like

DSLC5B

ESLC5B

ILLC5B

LB5B

Here it should return True condition only for LB5B.. where its returning true for all the above records