10-20-2014 09:58 AM
I have two data sources one with a list of customers and other information (Data Source A - SAS table), and another with a list of customers to be excluded (Data Source B -Excel Doc).
Is it possible to write a report in Visual Analytics based on Data Source A which excludes customers that are in Data Source B i.e. is there a facility in VA to do a subquery?
Or can this only be done in the Data Builder or another tool such as Enterprise Guide.
I am using version 6.4M1 of Visual Analytics.
Any guidance would be great.
10-20-2014 03:51 PM
As you suspect, the query can only be done using the Visual Analytics Data Builder or within Enterprise Guide prior to loading the result table into SAS Visual Analytics.