Changing measure to category upon loading the lasr

[L2Fly]

Hello and I apologize in advance if this post is not belong to this section and I will be happy to post it into its own group. I want to know if I do have a control on a column type when I load data into lasr. Foe example let's say my table contains an id column, name and address. When I load the table into lasr my id column as the default is set to measure. I know I can go ahead in report or data explore change it to category but every time I try to use it in a new report the default is measure. Is there a way to set it to category at all time? Thanks again

[SASKiwi]

I suspect your ID column is numeric. Change it to character and reload it into the LASR server and it will be treated as a category.

[L2Fly]

Thank you @SASKiwi, so the only way this will work is for me to change the property of original table column!  it is going to be hard to do that because (for example) I can't change the foreign key of the original table.  Not sure if possible to change the properties in the Metadata library where I register the table from SQL?

thank you again for your info and help.

[SASKiwi · Accepted solution]

One option would be to create an intermediate load table in SAS with the ID column converted then load that into VA. In my experience it is better to get your data organised properly outside of VA before loading rather than to try and "fix" it once it is in VA. This improves performance as well.

[L2Fly]

Hi @SASKiwi, agree with you and again thank you for your time and info.

Best