Forum Discussion

Money's avatar
Money
Icon for Helper I rankHelper I
3 years ago

Creating a new table with a calculated column by joining two tables depending on the match

Hi All,   I am trying to create a grid by joining two tables from two different data sources. One of IBM DB2 another of databricks. Unique ID Both the tables are Line Segment and Track Number.  Fro...
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

How should one Thor ID match one CWR ID? 

Money's avatar
Money
Icon for Helper I rankHelper I
3 years ago

Based on this condition

1. Requires same LS & Track Number

Mp range = Thor mp - cwr mp

2. Defines a Tight MP range -0.01 to 0.03 was recommended

3. Defines a Loose MP range 0.1 to 0.2 was recommended

4. Preferred to match with same rail ( thor rail = cwr rail ) within the loose MP range, but would match with opposite rail if there was no other joint around