Hi there ,
I have a dataset that looks like the below
Programme | Level | Year | Outcome | Total Attrition % | Headcount |
Sport | Level 4 | 2020/1 | Fail | 97% | 65 |
Sport | Level 4 | 2020/1 | Transfer | 7 | |
sport | Level 4 | 2020/1 | Withdrawn | 3% | 2 |
Sport | Level 4 | 2020/1 | Total Attrition | 13% | 67 |
Sport | Level 4 | 2021/2 | Fail | 80% | 25 |
Sport | Level 4 | 2021/2 | Transfer | 3 | |
Sport | Level 4 | 2021/2 | Withdrawn | 20% | 8 |
Sport | Level 4 | 2021/2 | Total Attrition | 12% | 33 |
I have hundreds of rows of data for various programmes and I tried filtering on the year and creating the table separately then appending the two columns (labelling them attrition % 2020/1, Headcount 2020/1 as below). This worked where I had three different programmes, but now that I am attempting it with several hundred, it is not showing the correct figures for the appended year. Any advice is appreciated.
This is the end table I'm aiming for.
Programme | Level | Outcome | Total Attrition % 2020/1 | Headcount 2020/1 | Total Attrition % 2021/2 | Headcount 2021/2 |
Sport | Level 4 | Fail | 97% | 65 | 80% | 25 |
Sport | Level 4 | Transfer | 7 | 3 | ||
sport | Level 4 | Withdrawn | 3% | 2 | 20% | 8 |
Sport | Level 4 | Total Attrition | 13% | 67 | 12% | 33 |
Solved! Go to Solution.
@EricaMN can I take a look at source / input files with your workflow?
Thank you very much @Qiu! it has worked. I hadn't thought to change my fields to strings so I could concatenate! much appreciated!
Thanks for replying, I was given the solution.
Thanks!
@EricaMN
Glad to help and thank you for the accept mark!