VA Text Topics: No data items in the active data can be set as unique row identifiers.

[znhnm]

Hello, 

I'd like to use the text topics object on VA interface. I have the text variable on my dataset, I can select that. I also have an ID column on my dataset, however, I cannot set that as the uniq identifier when trying to apply the text topics object because it says:

No data items in the active data can be set as unique row identifiers.

Here is the relevant SS.

What would be the reason for that and how could I solve this issue?

Regards!

[Sam_SAS · Accepted solution]

Hello,

Probably the issue is that your ID column has duplicate values. If you have permissions to perform data preparation tasks, then you could try generating a new ID column:

https://go.documentation.sas.com/doc/en/dprepcdc/v_023/datastudioadv/n0ooiqdt13mn6sn1ejbeyv4ech8d.ht...

It might also possible to create a calculated item with unique values within VA by concatenating your ID column with another one such as a date column. That would depend on your data.

You might want to create a list table of your data (including the ID column) and sort by frequency. That might help you find what the duplicates look like and determine how best to address them.

Let us know if that helps,

Sam