I am trying to change a field in the format 'yyyy-mm-dd hh:mm:ss' from a DateTime datatype to a Date datatype 'yyy-mm-dd'. I am accomplishing this in the Formula tool with Left([DateTimeField], 10) but I am unable to change the data type in the formula tool and the output still has the full DateTime...

I installed a new version of Alteryx, and now I'm missing a bunch of my Parse, In-Database, Reporting, Documentation, Interface, and Data Investigation tools! Do I need to go out to the Alteryx Gallery and download them for some reason?  How do I get these back?

Hi, How do I quickly change multiple fields at once in Tableau? Thanks.

I'm dumping a rather complicated dictionary to json, and something about the format is causing an error, "circular reference detected." I can't post the code but the basic format is {a[a1: a1,v: [ v1: v1,v2: v2 ] f: [ f1: f1, f2: f2 ]]} filled in from variables through the code and pulling from an A...

Hi, I have an Excel spreadsheet on my shared drive, and when I connect to the data and publish, I am unable to update my workbook with the new data.   Thanks, Rob

How can I show multiple periods (WTD, MTD, QTD, YTD, and LYTD) across my columns in one row like Microsoft excel?

I am trying to automate a process that reads in several xlsx workbooks. The sheet names on these workbooks change periodically so I cannot hard code the sheet names. Is there a way to get the sheet name for each of these files?   Thanks.

We are currently using LoadRunner Professional 12.60.  We have lots of LoadRunner scripts, so if our team upgrades to LoadRunner Professional 2020 SP2 , will all these scripts work or do I need to re-generate or modify all scripts? Any input would be great.