Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
@NickNelsonCCIM the easiest way I found was using the directory tool to pull in the files and then the ptyhon tool to read them
from ayx import Alteryx
from ayx import Alteryx
import pandas as pd
# Read the input data containing file paths
input_df = Alteryx.read("#1")
# Get the file path from FullPath column
file_path = input_df['FullPath'].iloc[0] # Get first file path
def read_vcf_file(vcf_path):
"""Read VCF file and return DataFrame"""
try:
# Read file and skip metadata lines starting with ##
with open(vcf_path, 'r') as f:
lines = [line for line in f if not line.startswith('##')]
# Create DataFrame from remaining lines
from io import StringIO
df = pd.read_csv(
StringIO(''.join(lines)),
sep='\t',
dtype={'#CHROM': str, 'POS': int, 'ID': str, 'REF': str, 'ALT': str},
low_memory=False
)
# Rename #CHROM to CHROM for easier handling
if '#CHROM' in df.columns:
df = df.rename(columns={'#CHROM': 'CHROM'})
return df
except Exception as e:
# Return error information
return pd.DataFrame({'Error': [f"Failed to read {vcf_path}: {str(e)}"]})
# Read the VCF file
vcf_data = read_vcf_file(file_path)
# Add source file path to the data
vcf_data['SourceFile'] = file_path
# Output to Alteryx
Alteryx.write(vcf_data, 1)
