Joining Filtered Datasets

[SteveDFW]

Hi 

I ran into this error while working in VA - data that contained a data filter can't be joined with another table.  Is there a way to filter a table and join with another table inside a VA report? 

Thanks.

Steve

[Sam_SAS · Accepted solution]

The doc offers this tip:
TIP: To join a data source that has a data source filter, convert it to an aggregated data source.

But in general, it is best practice to perform joins as part of your data preparation (i.e., outside of VA) if they will be used in a production report.

[SteveDFW]

Thanks.