I've Orders, Order Lines and BoM tables. I need to join those 3 tables.
- Orders Name column is begin with KS-2024
- BoM Name column is begin with BOM-
Metabase shows correct names when examining tables. After joining 3 of them Order name become BOM- and BoM name become KS-2024.
In the video Order is "Satış Sipariş", BoM is "Ürün Ağacı" and Order Line is "Satış Sipariş Satırı".
PS: If I convert it to SQL and run it, it shows correct data.
Diagnostic Info
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:125.0) Gecko/20100101 Firefox/125.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "21.0.2+13-LTS",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "21.0.2",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "21.0.2+13-LTS",
"os.name": "Linux",
"os.version": "5.15.0-101-generic",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.6.16-MariaDB-0ubuntu0.22.04.1"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
}
},
"run-mode": "prod",
"version": {
"date": "2024-04-11",
"tag": "v0.49.5",
"hash": "31c4887"
},
"settings": {
"report-timezone": "Turkey"
}
}
}