Alteryx Designer Desktop Discussions

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

Python embedded in workflow , export the csvs/data within the workflow?

wonka1234
10 - Fireball

Hi,

 

I have a python script. It runs in alteryx and exports to my local drive.  I use to_csv to export it.

I want run the script through alteryx and spit out the files or the results of the files to the workflow.

Can this be done?

 

2 REPLIES 2
wonka1234
10 - Fireball

trying to use 

 

alteryx.write(dummy,2) , where dummy is the dataframe and 2 is the number in the python anchor.

 

wonka1234_0-1661444663209.png

 

 

adding code:

 

for code, dummy in mainframe_data.groupby('Lookup'):
del dummy['Lookup']
if len(dummy) <=1000000:
dummy.to_csv(os.path.join(output_location,f"{(' '.join(dummy.File.unique()))[:6]}_Rules_{code}.csv"), sep='|', index=False)
alteryx.write(dummy,2)
else:
dummy.to_csv(os.path.join(output_location,f"{(' '.join(dummy.File.unique()))[:6]}_Rules_{code}.csv"), sep='|', index=False)
for file, dummy2 in dummy.groupby('File'):
if len(dummy2) <=1000000:
dummy2.to_csv(os.path.join(output_location,f"{(' '.join(dummy.File.unique()))[:6]}_Rules_{code}_{file.split('_')[1]}.csv"), sep='|', index=False)
alteryx.write(dummy2,2)
else:
dummy2.to_csv(os.path.join(output_location,f"{(' '.join(dummy.File.unique()))[:6]}_Rules_{code}_{file.split('_')[1]}.csv"), sep='|', index=False)
alteryx.write(dummy2,2)
del dummy2
del dummy
# Cleanup
del code

wonka1234
10 - Fireball

update - i needed to use "Alteryx" capitalize the A.

 

Now getting data in my browse tool. 1 brings it to my union tool (only 1 dataset showing). 2 brings to my browse tool (only 1 dataset showing) . 

 

However I have many files i need to bring in, how come only one file is being read in? Expecting 3, I need them to concatentate!

I want to union them to one.

Labels