Quick question on dummy data below. I want to split data after Country "Belgium" and want required mentioned output data every month.
Is it possible in Alteryx if someone can help me out over this.
Input data:
Report Date | Continent | Country | Foreign Holdings | Foreign US Purchases |
12/29/2023 | Europe | Belgium | 0 | 0 |
12/29/2023 | Canada | Canada | 0 | 0 |
12/29/2023 | Asia | Total Asia | 0 | 0 |
12/29/2023 | Africa | Total Africa | 0 | 0 |
12/29/2023 | Other Countries | Marshall Islands | 0 | 0 |
12/29/2023 | International and Regional | Depository Institutions | 0 | 0 |
12/29/2023 | Europe | Belgium | 1 | 1 |
12/29/2023 | Canada | Canada | 1 | 1 |
12/29/2023 | Asia | Total Asia | 1 | 1 |
12/29/2023 | Africa | Total Africa | 1 | 1 |
12/29/2023 | Other Countries | Marshall Islands | 1 | 1 |
12/29/2023 | International and Regional | Depository Institutions | 1 | 1 |
12/29/2023 | Europe | Belgium | 2 | 2 |
12/29/2023 | Canada | Canada | 2 | 2 |
12/29/2023 | Asia | Total Asia | 2 | 2 |
12/29/2023 | Africa | Total Africa | 2 | 2 |
12/29/2023 | Other Countries | Marshall Islands | 2 | 2 |
12/29/2023 | International and Regional | Depository Institutions | 2 | 2 |
Output data:
Report Date | Continent | Country | Foreign Holdings | Foreign US Purchases | Foreign Holdings | Foreign US Purchases | Foreign Holdings | Foreign US Purchases |
12/29/2023 | Europe | Belgium | 0 | 0 | 1 | 1 | 2 | 2 |
12/29/2023 | Canada | Canada | 0 | 0 | 1 | 1 | 2 | 2 |
12/29/2023 | Asia | Total Asia | 0 | 0 | 1 | 1 | 2 | 2 |
12/29/2023 | Africa | Total Africa | 0 | 0 | 1 | 1 | 2 | 2 |
12/29/2023 | Other Countries | Marshall Islands | 0 | 0 | 1 | 1 | 2 | 2 |
12/29/2023 | International and Regional | Depository Institutions | 0 | 0 | 1 | 1 | 2 | 2 |
The above workflow will work you'll just need to make a branch with a Crosstab for each Column in your Data set. You'll need 8 crosstabs and then change the Join to a Multi Join. You could probably batch macro it if you have more columns than the sample dataset.
Foreign US Sales | Foreign Valuation due to Price | All Other Holdings | All Other Purchases | All Other US Sales | All Other valuation Due to Price |
@cjaneczko I am attaching workflow which i have created.
This will sum up all the values which I don't want. If you can help further on this.