Inputs from multiple alteryx workflows

Question

I want to look into a folder with all of my Alteryx workflows and detail all of the input dependencies within those workflows.

Chaoued · Answer

@caltang That's so great, thank you so much

caltang · Answer

Actually, now that I think about it, it gets too slow with command line. Python would be better.

import pandas as pd
import os

# Read the data coming from the upstream Directory tool (connected to the '1' anchor)
# The data arrives as a pandas DataFrame.
df = Alteryx.read("#1")

# Define the output directory where you want the .txt files saved.
# Make sure this path exists on your system.
output_dir = r"C:\Your\Output\Folder\Path" # !! Update this path !!

# Ensure the output directory exists
if not os.path.exists(output_dir):
    os.makedirs(output_dir)

processed_files_list = []

# Iterate through each row in the DataFrame (each row is one file found by the Directory tool)
for index, row in df.iterrows():
    # 'FullPath' is a standard column from the Directory tool
    source_path = row['FullPath']

# Create the new filename with a .txt extension
    # 'FileName' is another standard column from the Directory tool
    new_filename = os.path.splitext(row['FileName'])[0] + ".txt"
    destination_path = os.path.join(output_dir, new_filename)

try:
        # Read the content of the .yxmd file (it's just text/XML)
        with open(source_path, 'r', encoding='utf-8') as f:
            content = f.read()

# Write the content to a new .txt file
        with open(destination_path, 'w', encoding='utf-8') as f:
            f.write(content)

processed_files_list.append({'OriginalPath': source_path, 'NewTxtPath': destination_path, 'Status': 'Success'})

except Exception as e:
        processed_files_list.append({'OriginalPath': source_path, 'NewTxtPath': 'N/A', 'Status': f'Error: {e}'})

# Create an output DataFrame to pass results back to the Alteryx workflow (optional)
output_df = pd.DataFrame(processed_files_list)

# Write the output DataFrame to the second anchor (named '2' by default)
Alteryx.write(output_df, "#2")

You can have the code above.

I tested it with a dummy workflow provided by someone in the community and it generates from .yxmd to .txt (but structured as .xml):

Chaoued · Answer

@caltang Hello,your response was very constructive. I would like to know which CMD command can be used to convert an Alteryx workflow into an XML file