This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This is a nice one with Alteryx. You want a formula tool to add your columns "Source_App" and "DC_CODE". You then use the cross tab tool which you find under transform. Use this new key field as your grouping, day as column headers and SUM_AMT as value.
A Formula tool can create the "SROUCE_APP_DC" field and Cross Tab will rearrange the data no problem. The tricky part to this is to fill out the table with all possible fields (since day 2 doesn't appear in the data).
In the attached solution I used a couple Summarize tools and a Generate Rows to create all the possible fields to join into the data before the Cross Tab.