How to decrypt the PII Data when the data source is a SQL View

For this we can have the following suggestions:

First:-

1. Create a Data Structure with all the data fields used from different tables similar as in SQL view.
2. Edit the existing flows where you create the records of all different 20 tables, add the Create step of newly created Data Structure or Selective Update step of newly created Data Structure, so that you have the data of all different data fields from different tables.

Second:-

1. Create a Data Structure with all the data fields used from different tables similar as in SQL view.
2. Create a new flow with Create Step of new Data Structure where you create data from all different tables at once and populate them in the report.