I have attached the dataset. I am trying to extract the number of vehicle spaces and the number of bicycle spaces, to then calculate the difference between the total number of vehicle and bicycle spaces available.
I had a go using the formula tool (GetWord) function to add 2 new columns then subtracting the 2 columns, then using the Summarize tool sum up the total. Is there an easier way?
Also, is the GetWord function the easiest method to extract the numeric values?
Gelöst! Gehe zu Lösung.
Could you attach the datasheet or zip the workflow?
Hi @CraigC_RG , I would use the RegEx tool's Parse function to do this:
Hope this helps!
Thank you. I haven't been using Alteryx that long and keep seeing the Regex expressions. I will use the support materials to try to get my head around it. If you don't mind me asking, have you got any suggestions/ tips to help me do that?
Hi @FinnCharlton I just noticed a slight issue in the Parsing tool of your workflow. In the "Detail" column, if there is only null value i.e. Record 21, then both new columns display a null value. As a result the totals are incorrect. Any suggestions as to how to replace the null values in the Detail column with "0"?
Sorry I meant Record 28
@CraigC_RG very good point, have amended the RegEx to avoid that: