Participate

Unless I'm missing something (very possible), it looks like the Auto Insights Uploader Tool requires credentials - an Access Key and a Secret.   Auto Insights Uploader   But when you create a token in Auto Insights it just gives you a single token, Auto Insights Token   What am I missing? ... View more

Using the Multi-Row Formula Tool Expression: IF [ID]=[Row+1:ID] AND [Date1=[Row+1:Date1: THEN 0 ELSE 1 ENDIF    The intended result would be a 0 in New Field for both A1234 entries (rather than a 1 for the second New Field entry of A1234) ... can someone help me as to what I am doing incorrectly?     Thank you ... View more

I have over 30 individual files. Each file has different fields except the column "Key".  How can I join all the files easily.   I also need only some of the fields from each file, I have the list of fields needed.   I tried *.csv in the input tool and Dynamic input they try to union the files but not join by "Key" column.   Could anyone advise please? ... View more

Hello everyone,   i have 2 separated inputs for this file, which is working fine, but i want to add a column reflecting the tab name taken from the excel input.   So the last column (Tab name) should look like something like this:   STATE Party_Id Subfile date audit Compliance Id Add_remove sheet date audit In subfile Same Date Audit Tab name ERISAPWC 8d4be98c-a17a-4f3e-ae47-481312657291   2 7/1/2020 Yes No AddRemoveJurisdiction 11132023 GAOCPA 4331af82-e2e6-4c58-9c91-7d9703727c07 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023 GAOCPA 78a421c6-c754-4963-824a-2d7b22992c40 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023 GAOCPA 79a5f774-e9d1-422e-a59e-a76853ecaa6f 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023 GAOCPA d17efb67-c4b0-402b-9290-7c83ab7e9ea1 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023 GAOCPA f4c4e8af-bb3b-4de1-a020-78821bae92a8 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023 GAOCPA f92c9431-a07f-4058-a666-dd75c6b16c02 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023 GAOCPA ff683926-dfd4-4f13-b76a-37e01ccccb3a 7/1/2021 4 7/1/2021 Yes Yes AddRemoveJurisdiction 11152023   Hope i explained my self correctly,   Thank you,   ... View more

Hello,    I'm new to working with Alteryx. I have a table with the headings: Name, Accesibility Clearance, Secret Clearance and Top Secret Clearance, Date of Accesibility Clearance Expiry, Date of Secret Clearance Expiry, and Date of Top Secret Clearance Expiry.  Some people only have accessibility; others have both secret and top secret. I want to achieve an output that would have the name as well as highest level of clearance they achieved and the corresponding expiry date.    The expiry date for the lower clearance may be more recent than the one for the person's higher clearance.    ANy help would be much appreciated.    Kate  ... View more