If the text data you want to parse does not have a consistent delimiter, then it’s time to move on to your next options! Parsing With the Formula Tool As you may be aware, the Formula tool can do a lot. This includes parsing strings! The documentation on String Functions is a comp...
This can be very problematic and creates a lot of time following all the branches that is connected after the 1st unique tool is used. My suggestion is to make this a warning instead of a fail or have an option to select fail or warning like the union tool is setup. This way people ...
Challenge #457: Profit and Loss Statement Hello Community Members, A solution to last week’s challenge can be found here. This challenge was submitted by Jacob Ward. Thank you, @SauronsBane, for this excellent contribution. As the year wraps up, your role as a business ... by AYXAcadem...
1) Enclose your field names in brackets, eg: [51010Balance] - that way if for some reason it is being interpreted otherwise, you forcibly tell Alteryx to read them as fields. 2) Try removing the keyword IS from your Case statement. I don't know if this will chang...