60 lines
1.5 KiB
Plaintext
60 lines
1.5 KiB
Plaintext
table AIA_AdvanceAnalysis_Mole
|
|
lineageTag: 5fc523f6-793c-4f6b-b658-d1df4c4281bb
|
|
|
|
column CMPS_DES_C
|
|
dataType: string
|
|
lineageTag: 2145d759-6e23-4797-8352-b3c14076b7a2
|
|
summarizeBy: none
|
|
sourceColumn: CMPS_DES_C
|
|
sortByColumn: RANK
|
|
|
|
changedProperty = SortByColumn
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column RANK
|
|
dataType: int64
|
|
formatString: 0
|
|
lineageTag: 8f4b893c-bf05-4840-b0a8-b78b663d6a67
|
|
summarizeBy: none
|
|
sourceColumn: RANK
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition AIA_AdvanceAnalysis_Mole = m
|
|
mode: import
|
|
queryGroup: 'OLD\AIA 独有表'
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
select CMPS_DES_C,RANK from dm.dm_td_aia_molecule_rank
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
),
|
|
#"Filtered Rows" = Table.SelectRows(Source, each [CMPS_DES_C] <> null and [CMPS_DES_C] <> "")
|
|
in
|
|
#"Filtered Rows"
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation PBI_ResultType = Table
|
|
|
|
annotation TabularEditor_TableGroup = 08
|
|
|