Discussions

Hi Expert I have trying to have dynamic Quarterly YoY comparison . scenario is given below   for example:  id region 20-Feb Mar-20 Apr-20 May-20 Jun-20 Jul-20 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-20 1 xyz 11000 15000 15000 23000 12000 9000 11000 15000 11000 12000 13000 14000 in above case i am doing qtd comparison. if i am in may 2021 and doing Quarterly YoY comparison i want to have the value as " Q1-2020+Q2-2020+May2020"  i don't want entire q3 data. similarly i want to make this comparison dynamically like on june it will be " Q1-2020+Q2-2020+May2020+June2020" and in july it will be "Q1-2020+Q2-2020+Q3-2020"  and so on. can we do that in alteryx.    ... View more

Hi all,   How would I go about automatically downloading the excel file in the following website, then select a specific tab within it? I have created a view on a static file and would like to be able to update this monthly as new government data comes in.   https://asic.gov.au/regulatory-resources/find-a-document/statistics/insolvency-statistics/insolvency-statistics-series-1a-companies-entering-external-administration-by-industry/     Cheers! ... View more

Hi,   I'm not sure if it is applicable that the Select tool can capture those labels found in the middle part since it those what I needed so that  I will not be deleting the upper part anymore.   I have attached an screenshot. From the screenshot, I would like to start getting the field name from "drilldown" and moving forward.   Please let me know if I am clear. Thanks. ... View more

I have a string field that looks like this "0.HTTP.2.WebText"  (a JSON_Name field).   And I want to remove the unwanted character using regex or any other formula in my workflow to achieve the output. The output should look like this - "HTTP_WebText". Any idea how to solve this, please?  Thanks.   ... View more

When I teach Alteryx to new users, this is a question that comes up a lot. I modified the below picture from the internet to help explain these tools.   With the Union Tool you stack data sets. In the picture above, the data from Table 1 is read first and then the data from Table 2 is added underneath the data from Table 1.     With the Join Tool, especially the J output anchor, you combine data from both tables. You will have new columns containing the data from the second table. It joins the tables on the similar column they have in common which is the Fruit column. In the example below it combined the data from Table 1 and Table 2 to have Color and Shape in a new data set for the corresponding Fruit.     If you took these same tables and used the Union Tool , you would have the results below;     Notice Table 2 data is directly after Table 1 data. There are Null values for the Shape column for Table 1, since Table 1 did not have this column in it. The same is true for the Color column for Table 2.       What about the Append Tool? This tool simply adds whatever data you connect your Source data (Table 2 in pic below) set to your Target data (Table 1). If you have one column it will add the field for every single row of your data set in a new column as shown below;     If you were to join the original two tables together using the Append Tool you would get every possible combination of columns and rows for both data sets. This is called a Cartesian Product . It joins the data from all tables without requiring any joining references. See the below picture for details.   There are certain circumstances where you may want to use the Append Tool in this way.   What if you were a car company and you needed to combine every car with every color interior and exterior. You would use this tool to create that data.   Hopefully these examples above help with the distinction between these tools. ... View more