ETL Missing Data - Assistance Needed
Hello, I am in need of assistance on trying to figure out why my ETL is some data. (I have tried a Data Fusion as well)
I have two tables/datasets where it is from tblCoverage left joined to tblProfile. Both tables are linked by a unique vendor code.
tblCoverage has a column named 'State' where it shows what state a vendor covers
tblProfile also has a column named 'State' which shows where the vendor is located and not necessarily what state they cover.
When I have a card built just using tblProfile, I am able to see values populated in a column named isActive (T/F). However, when a left join with tblCoverage was created through ETL, there are some records missing from these columns. Note that both datasets have a 'isActive' column, so I am using the column from tblProfile and not from tblCoverage. In addition, I have one filter on the card where I am filtering State = 'DC' (state from tblCoverage datset)
I confirmed there is no issue with the data source that the data is pulling from, and I think it is something with the join or how ETL was created.
Any assistance would be greatly appreciated and please let me know if you have any questions because I don't know if I explained well enough.
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board