Re: Load table twice and union all after difference filtering
As tresesco point out, if your data reduction is based on the user/login of the dash, then you can use Section Access to control that. If you want the dash itself only show specific data, then you can directly use the SQL in the load script.
And by the way, your case if the data is from the same table, the SQL query can be simpler like below:
Select * from Products where Family = ‘F1’ or Series = ‘S3’;