Extract Session ID & Client ID from API Headers in Alteryx

In this video, I walk through a real Alteryx Community post where the user needed to extract values like the Session ID and Client ID from API response headers. We break down the process step by step using common parsing tools to turn raw header text into usable fields. This is perfect for anyone working with API data and needing to cleanly extract values for use in subsequent requests. Use Text to Columns to split header text into rows Filter out only Set-Cookie lines Use conditional formulas to label Session ID vs Client ID Extract values using string manipulation (Left, Right, FindString) Cross Tab to reshape the data for downstream use By the end, you’ll have a clean data table with Session ID and Client ID fields ready to plug into your next API call. Watch the full post on the Alteryx Community here: 👉 https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Help-with-parsing-string-field-to-extract-specific-parts-of-the/td-p/1400131 — ✅ Like & subscribe for more real-world Alteryx examples 💬 Drop a comment if you want a walkthrough of your own post