Hallo, entschuldigt die Späte Antwort.
der Code sieht so aus.
Code:
let
Quelle = Csv.Document(Web.Contents("https://de.axonlab.com/filestorage/USB-Minotrol-16/qctget_MX" & "427" & "_MIC60_lyse_std.csv"),[Delimiter=",", Columns=144, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Erste Zeile als Überschriften verwenden" = Table.PromoteHeaders(Quelle, [PromoteAllScalars=true]),
#"Typ ändern" = Table.TransformColumnTypes(#"Erste Zeile als Überschriften verwenden",{{"Codeop", type text}, {"Date modif", type date}, {"No Lot", type text}, {"Type", type text}, {"Date exp", type date}, {"comment", type text}, {"WBC", type number}, {"RBC ", type number}, {"HGB ", type number}, {"HCT ", type number}, {"MCV ", Int64.Type}, {"MCH", type number}, {"MCHC", type number}, {"RDW ", type number}, {"PLT ", Int64.Type}, {"MPV ", type number}, {"PCT ", type number}, {"PDW ", type number}, {"LYM%", type number}, {"MON%", type number}, {"NEU%", type number}, {"EOS%", type number}, {"BAS%", type number}, {"ALYC%", type number}, {"LIC%", type number}, {"GRA%", type number}, {"LYM#", type number}, {"MON#", type number}, {"NEU#", type number}, {"EOS#", type number}, {"BAS#", type number}, {"ALY#", type number}, {"LIC#", type number}, {"GRA#", type number}, {"RET#", type number}, {"RET%", type number}, {"RETH%", type number}, {"RETM%", type number}, {"RETL%", type number}, {"MFI%", type number}, {"MAX ", type number}, {"CRP", type number}, {"Tol+- WBC", type number}, {"Tol+- RBC ", type number}, {"Tol+- HGB ", type number}, {"Tol+- HCT ", type number}, {"Tol+- MCV ", Int64.Type}, {"Tol+- MCH ", type number}, {"Tol+- MCHC ", type number}, {"Tol+- RDW ", type number}, {"Tol+- PLT ", Int64.Type}, {"Tol+- MPV ", type number}, {"Tol+- PCT ", type number}, {"Tol+- PDW ", type number}, {"Tol+- LYM%", type number}, {"Tol+- MON%", type number}, {"Tol+- NEU%", type number}, {"Tol+- EOS%", type number}, {"Tol+- BAS%", type number}, {"Tol+ ALYC%", type number}, {"Tol+- LIC%", type number}, {"Tol+- GRA%", type number}, {"Tol+- LYM#", type number}, {"Tol+- MON#", type number}, {"Tol+- NEU#", type number}, {"Tol+- EOS#", type number}, {"Tol+- BAS#", type number}, {"Tol+- ALY#", type number}, {"Tol+- LIC#", type number}, {"Tol+- GRA#", type number}, {"Tol+- RET#", type number}, {"Tol+- RET%", type number}, {"Tol+-RETH%", type number}, {"Tol+-RETM%", type number}, {"Tol+- RETL%", type number}, {"Tol+- MFI%", type number}, {"Tol+- MAX ", type number}, {"Tol+- CRP", type number}, {"WBC1Thr", type text}, {"WBC2Thr", type text}, {"WBC3Thr", type text}, {"ThrMic", type text}, {"ThrMac", type text}, {"PLT1Thr", type text}, {"Nol", type text}, {"Non", type text}, {"Noe", type text}, {"Ln", type text}, {"Rn", type text}, {"Ll", type text}, {"Al", type text}, {"Lmu", type text}, {"Lmd", type text}, {"Lmn", type text}, {"Mn", type text}, {"Rm", type text}, {"Nl", type text}, {"Ne", type text}, {"Rmn", type text}, {"ALNThr", type text}, {"ANEThr", type text}, {"AMNThr", type text}, {"BA1Thr", type text}, {"BA2Thr", type text}, {"BA3Thr", type text}, {"BA4Thr", type text}, {"R1Thr ", type text}, {"R2Thr ", type text}, {"R3Thr ", type text}, {"R4Thr ", type text}, {"F1Thr", type text}, {"F2Thr", type text}, {"F3Thr", type text}, {"F4Thr", type text}, {"AlLl%", type text}, {"AlLl#", type text}, {"AlLl1%", type text}, {"AlLl1#", type text}, {"AlNl%", type text}, {"AlNl#", type text}, {"AlMn%", type text}, {"AlMn#", type text}, {"AlLn%", type text}, {"AlLn#", type text}, {"AlNo%", type text}, {"AlNo#", type text}, {"AlRm%", type text}, {"AlRm#", type text}, {"AlRn%", type text}, {"AlRn#", type text}, {"AlLb%", type text}, {"AlLb#", type text}, {"AlNe%", type text}, {"AlNe#", type text}, {"AlCo%", type text}, {"AlMacP%", type text}, {"AlL1", type text}, {"AlMic ", type text}, {"AlMac ", type text}, {"AlNRBC%", type text}, {"AlCoRet%", type text}, {"AlPit%", type text}, {"AlPit#", type text}, {"Baso Factor", type text}})
in
#"Typ ändern"