Filtering

Hello,

I am trying to filter so that I remove secondary citizenship and keep null Citizenship and primary - "CITIZENSHIP_STATUS" <> 'S'
or "CITIZENSHIP_STATUS" IS NULL

What I want to do is say if there is remove secondary citizenship unless there is no primary so that it will not remove the secondary Citizenships that have no primary

Hopefully this makes sense

Thanks

Datasets

Accepted answers

mceleavey

Hi @rheatubby1234 ,

No problem. You just need a bit of Crosstab magic:

Hope this helps,

Filter_mceleavey.yxmd

All comments

mceleavey

@rheatubby1234 ,

If you post some data or dummy data representing your real world data we can build it for you.

rheatubby1234

Thank you. Here is some very simple data. What I want is for it to only pull the primary unless there is no primary and there is only secondary

Thanks

Example.xlsx

mceleavey

Hi @rheatubby1234 ,

I'm not sure if this is what you mean, but I've built the workflow to drop the secondary column and use the secondary as primary if the primary is null:

I hope this is what you need.

Filter_mceleavey.yxmd

rheatubby1234

Thank you, I tried this but I think I made this more complex. The data is coming from IN-DB so not Excel so there is only one column as such which is citizenship status and then they can have both primary and secondary in here so there isn't a column to arrange it by if that makes any sense