Problem with a 2nd Relationship Column showing in "Data Services Column Type Mappings" but not showing in Data Browser

[William_Lee]

Hi I’m trying to Import the “TitleAuthor” table with 2 relationships between the existing tables of “Titles” and “Authors”.

Here’s the TitleAuthor csv file with the custom defined relationship column headers pointing to their Parent Tables.

Here’s the Data Import results which shows both Relationship columns for both “Authors” and “Titles”

And here’s my Data Browser view for my imported “TitleAuthor” table with the missing “Titles” table relationship column

As a potential workaround fix. Is it possible to do the following steps:

Step 1. Re-importing the “TitleAuthor” table without the Relationship pointing to the “Titles” table but instead just leave it as a “title_id” Foreign Key column.

Step 2. Convert the existing “title_id” FK values into a Relationship pointing back to the “Titles” table?

I’m also attaching the 3 csv files that I’m using here.

Titles_TitleAuthors_Authors.rar (3.5 KB)

Thanks for your help!

[vladimir-upirov]

Hello @William_Lee

Seems like the second column is missed because there are two columns with the same name relation, try to rename any of them.

Regards, Vlad

[William_Lee]

That worked! I didn’t know if “relation” was a reserved word. Thanks!

[vladimir-upirov]

no, relation is not a reserved word.
you just tried to import a table with two columns with the same name relation

[William_Lee]

Thank you for spotting that out to me.