Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello! I have two tables:
YaM_stat:
StringId | INTEGER | NULLABLE | ||
CounterID | INTEGER | NULLABLE | ||
TimeVisit | DATE | NULLABLE | ||
Depth | INTEGER | NULLABLE | ||
Goals | STRING | NULLABLE | ||
Ad | INTEGER | NULLABLE | ||
UTMCampaign | STRING | NULLABLE | ||
UTMContent | STRING | NULLABLE | ||
UTMMedium | STRING | NULLABLE | ||
UTMSource | STRING | NULLABLE | ||
UTMTerm | STRING | NULLABLE | ||
Duration | INTEGER | NULLABLE | ||
Otkaznost | INTEGER | NULLABLE | ||
ClientId | STRING | NULLABLE |
YaD_stat:
AdId | STRING | NULLABLE | ||
CampaignId | STRING | NULLABLE | ||
Clicks | INTEGER | NULLABLE | ||
Cost | STRING | NULLABLE | ||
Date | DATE | NULLABLE | ||
Impressions | INTEGER | NULLABLE | ||
AvgCpc | STRING | NULLABLE | ||
Status_ads | STRING | NULLABLE | ||
Type | STRING | NULLABLE | ||
DisplayUrlPath | STRING | NULLABLE | ||
Href | STRING | NULLABLE | ||
Id_adset | STRING | NULLABLE | ||
Name_adset | STRING | NULLABLE | ||
Status_adset | STRING | NULLABLE | ||
EndCampaign | STRING | NULLABLE | ||
Name_campaign | STRING | NULLABLE | ||
StartCampaign | STRING | NULLABLE | ||
State | STRING | NULLABLE | ||
SourceId | STRING | NULLABLE | ||
AccountName | STRING | NULLABLE | ||
ClientInfo | STRING | NULLABLE | ||
ClientId | STRING | NULLABLE | ||
Login | STRING | NULLABLE |
I need to connect them by some field, but there is no direct match or fields with similar values. May be someone already did this?
If there is a relationship in the fields of the two tables, you can try to create a bridge table to connect the two tables.
I tried to connect UTMCampaign and Name_campaign, but they have different values. So I have no more ideas.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |