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...
Hi Anonymous
I guess what Vvelarde was trying to say was to create a calculated column using a formula like below and use this column to connect the two tables assuming that you are referring to Company as Delta Account.
New Unique ID =
IF (
LEFT ( Delta[Delta Account], 1 ) = "F",
Delta[Flex M3 ID],
Delta[Unique ID]
)