I'm using Alteryx version 2018.1.4.44311 (64bit)
I'm querying a table held in an iSeries DB2 DB but keep receiving the error:
'Internal Error in_getNumericAttribute:number too big'
I've tried using a WHERE clause to limit records but still no avail.
I've been running a workflow in Alteryx 2018.1 and publishing a data source to Tableau via the Tableau Server 1.0 tool. Today, I switched over to the Tableau Server 1.08.1 tool and when I run the workflow, I get this Warning message (screenshot below): Duplicates were found of "PublishToTableauServer\Publish to Tableau Server.yxmc".
The workflow still completes but I try to minimize/resolve warnings where possible. Does anyone have any idea how I can handle this warning?
When you "switched over" did you remove the old version of the tool?
This error usually comes from a macro/tool being installed twice or mapping a custom location that includes macros already installed.
I have problem in solving my project in the field of parsing
I'm having my input like this
|PARLE COOKIES HIDE&SEEK ASTD 4*120g OP|
|BRITANNIA 50-50 MASKA CHASKA 4*120g OP|
|TANG POW CONC LEMON 500g*2 OP|
|KURKURE NAMK ASSORTED 3*85g OP|
|SANTOOR SOAP SNDL&ALMND MILK 4*125g|
I need to parse only quantity of the product
for example i need my output
|PARLE COOKIES HIDE&SEEK ASTD||4|
|BRITANNIA 50-50 MASKA CHASKA||4|
|TANG POW CONC LEMON||2|
|KURKURE NAMK ASSORTED||3|
|SANTOOR SOAP SNDL&ALMND MILK||4|
please Assist me
I need to sum just the negative amounts of each line.
I need to get the results that X=-15, Y=-50, Z=-60.
Do you have any suggestions of how should i do it?
Thank you in advance.
I am attaching the solved workflow. I hope that helps
If you transpose your data first it will be a lot easier to work with. Then you can filter on values that are less than 0. After that it's just a simple sum :)
Part time Tableau, Part Time Alteryx. Full Time Awesome
Hello Alteryx Community,
I'm trying to figure out how much demand there would be remaining for a style after I replenish it. My challenge is the lead time to replenish varies from style to style. If it were all fixed, i'd filter my data set and summarize the forecast for weeks after the current week + weeks to replenish, but how to I calculate each style separately? Would it be a batch macro?
Example of data below:
|Week||Style End Week||Style||Forecast||Weeks to Replenish||Demand after Replenishment|
How would I calculate this? Am I on the right track?
Hi, I'm using version non-Admin Designer 11.8.4,
I installed pythonSDK example (ie Python - Input), but when I want to use it I've got error message "Can't find plugin AlteryxPythonSDK.pyd"
any idea ?
Can I use PythonSDK with this version ?
Can anyone share some tips in learning the interface tools? If there are any practice questions, it will be great.
Thank you so much in advance.
There are Macro and App challenges in the weekly challenge at https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275
These are great for practicing and have the benefit that you can see how different people have taken different approaches to solve the same problem.
I also think that the scripting and automation tools section of the help samples are a great way to learn.
Searching the community pages for questions about macros will provide a lot of interesting real life problems that people have faced that have been answered with the use of macros. Most of these will have sample workflows including the interface tools.
Check out the Crew macros. Not only are they very useful but if you open them up (right-click on tool | Open) you'll see neat ways of implementing complex processes. A lot of the standard tools are also macros that you can open to inspect.
Finally, for me, the best way to learn was by taking a repetitive task and forcing myself to write a macro to do it. I found it quite frustrating to start with until I got the hang of it but very rewarding once I got something working.
Hello - I am not able to see the scatter plot tool under data investigation section. Can someone help with this.
If you installed your predictive tools to your C:drive your predictive macros should be stored in the directory below. please check to see if that tool exists there. You should see a .yxmc file type for the Scatter Plot if it exists there. If you don't have the tool there, then either the tools was moved to another directory or deleted. You will have to reinstall your predictive tools if you cannot find the file.
C:\Program Files\Alteryx\R-3.3.2\plugin\Macros\Predictive Tools
I downloaded the tool (this morning) from the Gallery, installed it, and am trying to get it working using a very simple workflow (text input with 5 records straight to the Tableau tool)
I am running Alteryx 2018.1.4.44311 & Tableau Online
The Workflow appears to finish running successfully, but the data source does not appear in Tableau Online.
Any ideas? Do I need another tool after the Tableau tool?
How long does it take for the data source to appear in Tableau Online - seconds?
Hey, newbie here. I've looked at one live training on batch macros and some help pages, but I'm stuck and hope someone can help me with this.
The goal is to clean FAFSA data, but each week of data must be cleaned individually before being unioned. Because they are all cleaned the same way, I'm not sure what to have as an action. I'm not even 100% sure if a batch macro is the appropriate tool. So any suggestions are welcome. I've attached my work so you can get a better of idea of what I'm trying to do.
Sorry for the slow reply.
Seeing as you had already done the hard work of building the macro, here's how you can get it to work for each sheet...
Choose filename on the input screen:
Then use this new column as your grouping field on the batch macro:
This will process each file individually and then union them all together as a single output
Part time Tableau, Part Time Alteryx. Full Time Awesome