Forum Discussion
Tricky Relationship Situation
I have 2 data sources connected through a unique ID. One is a SQL data source, the other is from Salesforce. I have a one-to-many relationship between the 2 tables: So, 'Unique ID' from D...
Anonymous
I will try to created a calculated column in both tables with this condition.
New Column = Unique ID Column except That Co Start with F. If Start with F use Flex M3 ID.
And use this new column to related.
Victor
Hi Vvelarde, this makes perfect sense but I'm not exactly sure what that formula would look like. The Flex M3 ID only exists in one of my datasets.