topic Re: Alteryx Certification Exercises - Example Data Files in General Discussions

Alteryx Certification Exercises - Example Data Files

pderwa12 — Wed, 27 Apr 2022 17:49:29 GMT

I am going through the Alteryx Certification training documents. Each has exercises that reference specific files that I do not have. Are these files stored some where that I can use. Some are excel, some are Alteryx database, etc.

Re: Alteryx Certification Exercises - Example Data Files

Luke_C — Thu, 28 Apr 2022 12:19:36 GMT

Hi @pderwa12 can you give a specific example from the training document?

Re: Alteryx Certification Exercises - Example Data Files

pderwa12 — Thu, 28 Apr 2022 20:29:05 GMT

I am going through an exercise right now and am simply trying to recreate a workflow that someone else created but I am getting this error message. See this diagram:

Here is the error message I am getting at the 'multi-row formula tool:

Here is the formula I am using. I just copied it from the example, as is and it works perfectly in the model, it is just not working in the one that I created.

if [RecordID]=1 and !isnull([Value]) then
tostring(datetimeparse(regex_replace(replace([Value], " Total",""),".+- (.+)","$1"),'%b %d, %Y'))
elseif [RecordID]=1 and !isempty([Row-1:Value]) then [Row-1:Value]
elseif [RecordID]=1 then "DMA"
elseif [RecordID]=2 and isnull([value]) then "Total - Point of Sale"
elseif isnull(value) then 0
else value endif

The problem is that the record ID (numeric) is not getting passed to the filter tool and I do not know why. When I select the 'basic filter', it should give me an option to select recordid but there is nothing to select.

What could possibly be wrong?

Re: Alteryx Certification Exercises - Example Data Files

Luke_C — Thu, 28 Apr 2022 20:47:23 GMT

Hi @pderwa12

You're trying to update a numeric field with text values. I'd personally suggest you select 'Create New Field' rather than 'Update Existing field'. Then configure the new field's name, data type (probably V_STRING), and length (long enough to capture all your values), and see if you still have the issue.

Re: Alteryx Certification Exercises - Example Data Files

pderwa12 — Fri, 29 Apr 2022 14:46:50 GMT

I did what you suggested and then went back to the tool and it let me change it back to what I was originally trying to do. After that, I was able to simulate the entire workflow from the example, and it worked. I guess there are just some finnicky things about Alteryx that you have to play around with. Thank you for looking into this.

Re: Alteryx Certification Exercises - Example Data Files

Luke_C — Fri, 29 Apr 2022 14:57:53 GMT

Great! Don't forget to mark the solution if you're set. I'd suggest checking out the below training on data types - regardless of if it's Alteryx or any other programming language, strings and numbers function very differently when used in expressions.

https://community.alteryx.com/t5/Interactive-Lessons/Understanding-Data-Types/ta-p/73958

Re: Alteryx Certification Exercises - Example Data Files

pderwa12 — Fri, 29 Apr 2022 15:13:41 GMT

Thanks again. I do understand the difference between the different data types, I just didn't understand why that error message was showing when, according to the model, it should have worked. So the answer you provided did not fix the issue. I did change it to your suggestion but, later was able to go back, and change it back to what I had originally entered. Should I still accept that as the solution. I suppose for trouble shooting, it is something to keep in mind but it did not resolve the overall issue.

Re: Alteryx Certification Exercises - Example Data Files

Luke_C — Fri, 29 Apr 2022 16:10:36 GMT

What's the remaining issue? That the record ID field isn't showing as an option in the filter tool? Are you able to share the workflow?

Re: Alteryx Certification Exercises - Example Data Files

pderwa12 — Fri, 29 Apr 2022 16:17:55 GMT

There are no remaining issues. I changed it to the original data type and the workflow worked (not the one you suggested). I did have to delete and add certain tools back into the workflow in order for it to work also. So, what I learned from this is that Alteryx can be kind of finnicky and you sometimes have to delete and add the tool back in to get the correct results.

Re: Alteryx Certification Exercises - Example Data Files

pderwa12 — Fri, 29 Apr 2022 16:25:35 GMT

I do have another question. The workflow model had this tool in the workflow:

I cannot find this in my tool bar. I checked all the categories and could not find it. Is it possible that the Alteryx version I am using does not have that tool? The version I am using is:

When I open Alteryx, there is a note under the tools bar that says 'A newer version of Alteryx Designer x64 is available. Then there is an option at the end of the screen that says 'Click here for options'.

When I click the option to download the latest version, I am getting this message. I don't have the key so cannot download it. I work at Ford Motor Company and downloaded the original version from our software store.

Re: Alteryx Certification Exercises - Example Data Files

Luke_C — Fri, 29 Apr 2022 16:21:50 GMT

Great! Best of luck with the certification exam!

Re: Alteryx Certification Exercises - Example Data Files

Luke_C — Fri, 29 Apr 2022 16:23:36 GMT

@pderwa12 That's the dynamic rename tool in the developer palette. It would be in your alteryx, but by default the developer palette may not be shown on your toolbar. Just click the plus button all the way at the right to add it.

Re: Alteryx Certification Exercises - Example Data Files

pderwa12 — Fri, 29 Apr 2022 16:35:11 GMT

Awesome. Thank you. When I clicked the "+" it showed that the 'Developer' tool palette was already selected. The problem is that to the right of the "+" sign, there is an arrow, I just needed to hit that a few times to see the rest of the tool palettes. I learned something else new again. Thanks again!!