Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hey @david_shishir,
See the attached solution.
Prob. renaming the forecast before the Join could be a good idea.
P.S. Not sure why you talk about unions here, as this seems to me like a Join-only job?
Hey @david_shishir, although you mention a Union in your request, you also mention Joining forecasts. With the nature of your request, I've assumed you need the latter but let me know if this isn't what you're after. The workflow here first of all transposes both inputs so that their months can be easily compared. After that, the formula tells Alteryx to fill in the missing (null) actuals with the values coming from the forecast - if the data isn't missing (i.e. there are actuals), this will be maintained. Once these previously missing values have been populated, the data is then sorted to get the right month order, before being cross-tabbed back into the original format. Please let us know if there's any issues with this or if the request was different!
