This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi everyone, I have a following workflow: and I want to change date field from string to date. When I am running workflow for the first time, its throwing error, because the field is not visible in the tool to be chosen. I have to run the workflow once to get the all fields and then choose and run again. However, this issue is happening everytime when I am closing the Alteryx and opening workflow again which should not happen. P.S. Same is happening in Unique Tool as well. Any ideas how I can solve it?
... View more
Hi Community, I'm trying to send an email to the intended "offender".So eg I have a file with multiples email address tagged to different person. So if "Penalised" = "Yes" then I'd require the email to read email address dynamically in this case, abc@asd.com & zxc@asd.com. Understand we can tagged "offender" and reflect in the email body using layout tool but is this possible to input intended email add straight in the email tool? Thanks in advance. Penalised email add Yes abc@asd.com No 123@asd.com Yes zxc@asd.com
... View more
I have been trying to find an efficient way to compare 2 data sets to find missing or extra information, and was wondering if anyone would be able to help me out. I have the below example. Dataset 1 is sort of a "key", where I have a set of values in column B that should be associated with a set value in column A. In dataset 2, I can have multiple records that contain the set value in column B, and then the values I want to compare are in column C. So I want to use the relationships of column A-B on Dataset 1 to compare to Column B-C on dataset 2. I have included my ideal output as well.
... View more
Context: I need to build to a single dataset that shows Product sales week on week when on-promotion vs when not on promotion. I already have a dataset that has all the products and their sales figures when not on sale, week on week. Challenge: The product promotion data comes in the form of a monthly excel output, for which the weekly data is split by weeks in different sheets. What is the most efficient way to stitch together what is notionally 12 excels and 52 sheets (they are all the same format column-wise)? It's also worth noting each month different items go on sale and sometimes they back on sale after a couple of months, so assume that I can use the total product list as a common identifier.
... View more
