Hi! My dataset includes a column that includes the fiscal year (e.g. "FY22", "FY23",... etc.) and another column that contains names. I want to delete the rows where the name exists in FY23 but not in any of the other years.
Hi @Tala
Can you share a sample of your input/expected output?
I unfortunately can not. Is there any way you can help me without a sample?
Take a look at the attached workflow and see if it make sense.
1-With summarize + filter you can remove names with only FY23
2-You can then join the data back by name
Thank you but I don't want to remove all names with FY23, I want to remove the row if the name exists in FY23 but does NOT exist in the other fiscal years
I believe that this workflow is doing exactly what you need. With this summarize concatenate + filter, i am removing just names with ONLY FY23. Please open it and take a look.
I did and I understand what you're saying but what I'm trying to do is keep the names if they exist in FY23 and in any of the other years, I want to remove the name if it exists inn FY23 but does NOT exist in other fiscal years. In other words I don't want to remove all names with FY23
I am not removing names if they exist in 23 + another year. As you can see, John is on the output.
Anyway, if this is not the case i am not really understanding. Using a fake input dataset like the one that i provided, can you mock a sample output dataset? So it will be more clear what you need.
Sorry for the late reply. Sure thing, "sample1" is a sample of the input and "sampleoutput" is a sample of the output
Oh I'm sorry, I just realized that I kept the end dates and submitted for period end as "2023" but the fiscal year isn't FY23, you can just ignore them and use the "Type" column which is the fiscal year
Actually I think I made it work using the previous workflow you showed me so thank you very much but do you know how I can find the difference between the hours worked each year? Hours in FY22 - Hours in FY23 and etc.. and I want it to be DYNAMIC
If you can help with that then use the files I attached below instead of the ones I sent earlier since they're more similar to what I want.
Yes, try the attached version.
Yes I did that and it worked, thank you so much but how can I subtract the hours in FY22 from the hours in FY23 and etc... dynamically?
