JohnDanter2
VIP Member
Hi folks
I have a request to clear data from SOs (F4211 and F42119) based on AN8 SHAN and DCTOs for GDPR purposes.
I have a tricky one in that I have a UBE reading over F4211 and then F42119 in 2 separate UBE sections, the reason is as follows
I was using a union join over ONE section up until a request came in to also filter by MLNM on F4006, so the union join would no longer work.
So I had to create 2 sections with 2 different BSVWs A = F4211 + F4006 (V554211E) and B = F42119 + F4006 (V554211B)
Issue I now have is system function Use Data/Selection From another Section will not work as the views are not the SAME view.
I was going to use a workfile to store hit AN8 SHAN and DCTOs and pass this down into section B, but was if section never hit a certain AN8, I would skip this in section B
So does anyone know a way of getting runtime data selection from the F4211 section down into the F42119 section
Or....does someone know a way to get a union join on F4211 and F42119 to also select data off of F4006
Thanks
John
I have a request to clear data from SOs (F4211 and F42119) based on AN8 SHAN and DCTOs for GDPR purposes.
I have a tricky one in that I have a UBE reading over F4211 and then F42119 in 2 separate UBE sections, the reason is as follows
I was using a union join over ONE section up until a request came in to also filter by MLNM on F4006, so the union join would no longer work.
So I had to create 2 sections with 2 different BSVWs A = F4211 + F4006 (V554211E) and B = F42119 + F4006 (V554211B)
Issue I now have is system function Use Data/Selection From another Section will not work as the views are not the SAME view.
I was going to use a workfile to store hit AN8 SHAN and DCTOs and pass this down into section B, but was if section never hit a certain AN8, I would skip this in section B
So does anyone know a way of getting runtime data selection from the F4211 section down into the F42119 section
Or....does someone know a way to get a union join on F4211 and F42119 to also select data off of F4006
Thanks
John