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

znhnm — Thu, 30 May 2024 09:58:30 GMT

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!

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

Sam_SAS — Thu, 30 May 2024 12:43:12 GMT

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.htm

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

topic Re: VA Text Topics: No data items in the active data can be set as unique row identifiers. in SAS Visual Analytics

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

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