Skip to main content
November 28, 2024
Question

Changing the main column option is no longer available with data linking

  • November 28, 2024
  • 2 replies
  • 62 views

Data linking change main column option is no longer available , in my sheet i had 2 columns 1 for id the other for name both are unique 

I used to switch between sheets to fix typos, but now I'm stuck as the option is no longer available. Additionally, some of my sheets have worng column as the main column  , and I need to use IDs instead of names  . Please help.

Comments

omar92Author
November 29, 2024

this what iu see now 

but htis is how it should be 
 

 

Zuzia S
Lucid community team
November 29, 2024

Hi ​@omar92

Thanks for your post! 

Could you please confirm whether you have toggled the ‘My dataset doesn’t contain reference keys’ option when importing your data, as per the screenshot below?

 

 

Indeed, if you do not add a reference key upon import, you will not be able to add one in your document later unless you go through the entire import flow again. Then, the options showing up when right-clicking on the header of a column are the following: 

 

 

Could you please make sure to select a column of your data that contains reference keys when linking your data in order for you to be able to change the reference key column afterwards? As such: 

 

 

Let us know how it goes! Hope this helps!