Discussions

Hi everyone, I’m creating a workflow in Alteryx that will call a Macro on a scheduled basis. The Macro receives the following inputs via a Text Input tool: Source Oracle table name Filter / WHERE clause (if applicable) Destination database/schema name in Snowflake Normally, the Macro processing is straightforward: I use Input Data (Oracle) and Output Data (Snowflake) to establish connections, and a few Control Parameters allow the Macro to sequentially move a set of tables from Oracle to Snowflake. However, this time I’m encountering some CLOB and BLOB fields that require additional processing, and I need some guidance. I have two main questions: Dynamic routing based on data type a) How can I analyze or parse an incoming table dynamically to identify the data types of each column? b) Once the data types are identified, how can I route them to different pipelines for processing? For example: Text, Date, Number → Default Snowflake datatypes BLOB → Use the BLOB Convert tool CLOB  Handling CLOBs The sample table I tested on doesn’t have large CLOB values, but the workflow still times out at this step. I assume some additional processing is needed to move the CLOB. How should I handle this efficiently in Alteryx? I’m relatively new to Alteryx and have only used a limited set of tools, so any tips, best practices, or example workflows for handling CLOBs and BLOBs in a scheduled Macro would be greatly appreciated. Thank you in advance for your guidance! ... View more

This has to be a simple question to answer, but I just can't seem to find the answer, or accurately use the tools I thought I could use (cross tab or Dynamic rename) I just want to take the result under the 'Begin-Year' column and add it to the existing 'Submit Count' column header.     Thank you in advance, Kim ... View more

Working on a workflow that needs to clean, score, and route leads coming from different traffic sources. Phonexa gives me the call tracking part, but once the data lands in Alteryx, I’m still refining the best way to distribute leads automatically without slowing everything down. Curious how others structure their pipelines when volumes grow and multiple campaigns run at once. ... View more

Hello all.  I am trying to access a file from an internal SFTP server that we have.  I am using the Text Input and the Download tools in Designer (v 2024.2).  Please refer to the attached Download configuration details (I set-up DCM for the access to the SFTP server).  When I run the process, I get the following error in Designer:  Error transferring data.  Func 'curl_easy_perform' failed, ret = 35, desc = SSL connect error.  I don't believe that our SFTP server also requires a SSH key.  Any thoughts on why I am getting this error?   Mike ... View more

Hi,   My data set has 260 business days, 15 string fields, and 1 numeric field.    Below is a simple example. This is a perfect example that the trade HQLA L1 with CP 1 always occurs every day, but in my data set it's varied. The trade could be matured and not rebooked after a few days. 'm going to use the DoD result to calculate the standard deviation later of the same field combination. How do I calculate the DoD?   Date Att1 Att2 Att3 Amount DoD   Date Att1 Att2 Att3 Amount DoD   Date Att1 Att2 Att3 Amount DoD 31-Oct Bank 1 HQLA L1 CP 1 99     31-Oct Bank 1 HQLA L2 CP 1 0     31-Oct Bank 1 HQLA L3 CP 1 49   30-Oct Bank 1 HQLA L1 CP 1 81 18   30-Oct Bank 1 HQLA L2 CP 1 12 -12   30-Oct Bank 1 HQLA L3 CP 1 71 -22 29-Oct Bank 1 HQLA L1 CP 1 59 22   29-Oct Bank 1 HQLA L2 CP 1 63 -51   29-Oct Bank 1 HQLA L3 CP 1 49 22 28-Oct Bank 1 HQLA L1 CP 1 57 2   28-Oct Bank 1 HQLA L2 CP 1 46 17   28-Oct Bank 1 HQLA L3 CP 1 92 -43 27-Oct Bank 1 HQLA L1 CP 1 16 41   27-Oct Bank 1 HQLA L2 CP 1 68 -22   27-Oct Bank 1 HQLA L3 CP 1 85 7 26-Oct Bank 1 HQLA L1 CP 1 83 -67   26-Oct Bank 1 HQLA L2 CP 1 6 62   26-Oct Bank 1 HQLA L3 CP 1 54 31 25-Oct Bank 1 HQLA L1 CP 1 66 17   25-Oct Bank 1 HQLA L2 CP 1 75 -69   25-Oct Bank 1 HQLA L3 CP 1 50 4 24-Oct Bank 1 HQLA L1 CP 1 19 47   24-Oct Bank 1 HQLA L2 CP 1 46 29   24-Oct Bank 1 HQLA L3 CP 1 14 36 23-Oct Bank 1 HQLA L1 CP 1 49 -30   23-Oct Bank 1 HQLA L2 CP 1 13 33   23-Oct Bank 1 HQLA L3 CP 1 27 -13 22-Oct Bank 1 HQLA L1 CP 1 33 16   22-Oct Bank 1 HQLA L2 CP 1 70 -57   22-Oct Bank 1 HQLA L3 CP 1 25 2 21-Oct Bank 1 HQLA L1 CP 1 11 22   21-Oct Bank 1 HQLA L2 CP 1 87 -17   21-Oct Bank 1 HQLA L3 CP 1 83 -58 20-Oct Bank 1 HQLA L1 CP 1 44 -33   20-Oct Bank 1 HQLA L2 CP 1 42 45   20-Oct Bank 1 HQLA L3 CP 1 21 62 19-Oct Bank 1 HQLA L1 CP 1 71 -27   19-Oct Bank 1 HQLA L2 CP 1 55 -13   19-Oct Bank 1 HQLA L3 CP 1 36 -15 18-Oct Bank 1 HQLA L1 CP 1 15 56   18-Oct Bank 1 HQLA L2 CP 1 32 23   18-Oct Bank 1 HQLA L3 CP 1 75 -39 17-Oct Bank 1 HQLA L1 CP 1 1 14   17-Oct Bank 1 HQLA L2 CP 1 96 -64   17-Oct Bank 1 HQLA L3 CP 1 56 19 16-Oct Bank 1 HQLA L1 CP 1 90 -89   16-Oct Bank 1 HQLA L2 CP 1 28 68   16-Oct Bank 1 HQLA L3 CP 1 10 46 15-Oct Bank 1 HQLA L1 CP 1 99 -9   15-Oct Bank 1 HQLA L2 CP 1 17 11   15-Oct Bank 1 HQLA L3 CP 1 75 -65 14-Oct Bank 1 HQLA L1 CP 1 33 66   14-Oct Bank 1 HQLA L2 CP 1 88 -71   14-Oct Bank 1 HQLA L3 CP 1 26 49 13-Oct Bank 1 HQLA L1 CP 1 42 -9   13-Oct Bank 1 HQLA L2 CP 1 96 -8   13-Oct Bank 1 HQLA L3 CP 1 45 -19 12-Oct Bank 1 HQLA L1 CP 1 75 -33   12-Oct Bank 1 HQLA L2 CP 1 36 60   12-Oct Bank 1 HQLA L3 CP 1 18 27 11-Oct Bank 1 HQLA L1 CP 1 47 28   11-Oct Bank 1 HQLA L2 CP 1 28 8   11-Oct Bank 1 HQLA L3 CP 1 50 -32 10-Oct Bank 1 HQLA L1 CP 1 50 -3   10-Oct Bank 1 HQLA L2 CP 1 17 11   10-Oct Bank 1 HQLA L3 CP 1 24 26 9-Oct Bank 1 HQLA L1 CP 1 82 -32   9-Oct Bank 1 HQLA L2 CP 1 78 -61   9-Oct Bank 1 HQLA L3 CP 1 4 20 8-Oct Bank 1 HQLA L1 CP 1 67 15   8-Oct Bank 1 HQLA L2 CP 1 20 58   8-Oct Bank 1 HQLA L3 CP 1 3 1 7-Oct Bank 1 HQLA L1 CP 1 43 24   7-Oct Bank 1 HQLA L2 CP 1 36 -16   7-Oct Bank 1 HQLA L3 CP 1 63 -60 6-Oct Bank 1 HQLA L1 CP 1 25 18   6-Oct Bank 1 HQLA L2 CP 1 53 -17   6-Oct Bank 1 HQLA L3 CP 1 32 31 5-Oct Bank 1 HQLA L1 CP 1 100 -75   5-Oct Bank 1 HQLA L2 CP 1 86 -33   5-Oct Bank 1 HQLA L3 CP 1 35 -3 4-Oct Bank 1 HQLA L1 CP 1 32 68   4-Oct Bank 1 HQLA L2 CP 1 46 40   4-Oct Bank 1 HQLA L3 CP 1 74 -39 3-Oct Bank 1 HQLA L1 CP 1 17 15   3-Oct Bank 1 HQLA L2 CP 1 47 -1   3-Oct Bank 1 HQLA L3 CP 1 39 35 2-Oct Bank 1 HQLA L1 CP 1 52 -35   2-Oct Bank 1 HQLA L2 CP 1 72 -25   2-Oct Bank 1 HQLA L3 CP 1 23 16 1-Oct Bank 1 HQLA L1 CP 1 31 21   1-Oct Bank 1 HQLA L2 CP 1 19 53   1-Oct Bank 1 HQLA L3 CP 1 74 -51 ... View more