Try the following RegEx string in the RegEx tool (Parse method):
This ignores anything before "WEB-SO followed by numbers", and then ignores anything after the last number. (NOTE: This assumes that your SO numbers are always numbers, let me know if that's not the case.)
To get just the numbers, you could do another RegEx tool that just uses the following formula in a RegEx tool (Parse method) on the results of the first one. (You could also use RegEx_Replace formula in the formula tool, same RegEx string)
That will isolate just the numbers for you within the marked group (\d+).
Does that work for you?
As suggested by Jerad from the Alteryx Support Team, we solved this situation. Alteryx processes need to be whitelisted so the software can act as it should.
So our IT Team did this and now the tool is working.
Thank you very much everybody for your help.
This is solved.
How about something like the attached?
I have also included a more complex sample data.
- Record ID to generate a record sequence identifier
- Multi-Row Formula to add a Family ID based on when Generate is 1
- Formula to add the field Parent Generation
- Join with self on Family ID and Parent Generation to Generation, keeping just the fields needed
- Filter out potential Parent record that are prior
- Sort by Record ID and Parent Record ID
- Select to keep just the first record per Record ID
- Join Multiple to bring the full data back in
Can you calculate the difference in days instead of months, and round up/down based on the # of days?
Alternatively, if you converted PD date to the 1st of the month (DateTimeTrim formula should work), then you'd be able to compare 2017-07-01 to each of the SEDF dates, which might get you closer to the first option (0 and -1) that you were looking for... but it would change the last row to 2, which I'm not sure is correct either.
If either of these seem like options worth pursuing in more detail, let me know if you need some more tweaking!
Hi @shlokmittal - this error usually indicates that the .yxdb is corrupt. This is rare, but sometimes occurs when the process for writing is interuppted somehow - power cuts, antivirus interferring with the file while writing, etc. I would suggest re-writing that .yxdb and trying again.
Thanks you all for the Solutions.
I figured it out myself using Dynamic Rename Tool. So from Input 2 I rename my column using the option Take Field names from right Input Rows and then specify the Old and New column Names. Worked perfect for me.
I have a guess for you Phillip. Again this is just a gUESS. Oracle is vErY particular about CaPItalIzAtIOn.
Your Tablename is likely all CAPS in oracle. Check your SQL to make sure that there is a match.
Try the attached!
1. Use the Generate Rows tool to create a new line for every number X-1 until you get to 1
2. Formula tool to concatenate the original column name with the new RowCount # to get your combination
Does that work? :)
It looks like it is the difference of using .xlsx (Excel 2007 +) vs .xls (Excel 97-2003) file types. Are you able to save the file as a .xlsx file? This would give you the option to say what row the data starts on.
Unfortunately, you would need to create these extra fields or run the model in the R tool. If desired, the macros can be opened and adapted by right clicking on the tool on the canvas and selecting 'open macro' then saving as a copy.