Skip to main content

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.

this what iu see now 

but htis is how it should be 
 

 


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!

 


Reply