Unable to generate the data from website.

[duttaabhishek]

Hello every one,

I am trying to generate some data from the website (https://www.transparency.org/en/cpi/2024). I am trying to generate the data from the table which have the score, country and rank listed towards the left of the screen of the website. However I am not getting the results generated  out of it.

I built the attached workflow for the same but somehow its not working for me. Can someone pls help me fix the workflow. 

[Vinod28]

Hi @duttaabhishek ,

I hope you're doing well.

Please find attached the 2024 Corruption Perceptions Index (CPI) dataset, which includes the Country, Score, and Rank for 180 countries as published by Transparency International.

You can import this dataset into Alteryx for analysis and visualisation. Below is a quick guide to help you get started:

---

Step-by-Step Guide in Alteryx

1. Input the Data: Use the Input Data tool to load the attached CSV.

2. Sort: Use the Sort tool to arrange countries by Score (descending) or Rank (ascending).

3. Filter (optional): Use the Filter tool to isolate high- or low-scoring countries (e.g., Score > 70 or Rank ≤ 10).

4. Summarize: Use the Summarize tool to calculate averages, minimum/maximum values, and counts.

5. Visualize (optional): Use Interactive Chart or Reporting Tools to generate graphs like bar charts or pie charts.

If you need to analyze regional trends, you can join this dataset with a country-to-region mapping file and summarize region-wise averages.