From what you are describing this can easily be accomplished in two steps. First do the join between the two datasets. The default options (on the options tab in the lookup definition) will show a left outer lookup. Don't change this. After the join is executed, bring up the filtergram on the "Sources" column. It is the very first column of data. This system managed column will show you which records came from each dataset. Filter for the row that shows data from both datasets, then click on the remove tool and save it. You will be left with only the records that were in the initial dataset that are not in the second dataset.

@ahatisTWRegarding your first scenario, this is by design. Even though users could belong in the same group within Paxata, there might be further ACL set on the SOR, so replicating groups set at the data source level to the imported dataset might expose data to users that do not otherwise have access to it.

The second scenario, after further review, we found some inconsistent behavior which needs to be addressed on our side. Your expectation is correct, answersets should inherit permissions from the project. Our development team is looking into it.

In order to get the Sum of all the values in a single column, Please follow the steps mentioned below:

Step 1 : Load the desired DatasetStep 2: Compute a new column with any value - (In this case "Random") and create a lens of this view.

Step 3: Use the group by function, to group by column test and perform the aggregate function on Column A to get the sum of all values in Column AStep 4: Perform a lookup to the "Look up View" created in Step 2 using the following connection optionsStep 5: Remove the undesired columns.

There are many ways to accomplish this. The way that I would probably go about it would be run a "Find and Replace" all "N" for <blank>. You can do this across all four columns in one step using the column picker.