// tags let Source = Csv.Document(File.Contents("\Mac\Home\Documents\Google drive insync\Google Drive\Мои Исследования\Golos power bi\all comments golos2.txt"),[Delimiter="#(tab)", Columns=45, Encoding=65001, QuoteStyle=QuoteStyle.Csv]), #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]), #"Removed Other Columns" = Table.SelectColumns(#"Promoted Headers",{"ID", "json_metadata"}), #"Removed Errors" = Table.RemoveRowsWithErrors(#"Removed Other Columns"), #"Parsed JSON" = Table.TransformColumns(#"Removed Errors",{{"json_metadata", Json.Document}}), #"Expanded json_metadata" = Table.ExpandRecordColumn(#"Parsed JSON", "json_metadata", {"tags"}, {"tags"}), #"Expanded tags1" = Table.ExpandListColumn(#"Expanded json_metadata", "tags"), #"Changed Type" = Table.TransformColumnTypes(#"Expanded tags1",{{"ID", Int64.Type}}),
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN MESSAGE. | |
Di9YC1huoW3Uqia kKV77J4SNeisdoF w5NIxR7pSDA3Rw2 kQjjQ62s004r8te | |
nqgiNPrz8p3d9RT efp8VESB5hfTCKq 6Xr2MZHgg6xg8sl 2zf2hthidQHOle5 | |
FOOruKxx0OIPzH4 TM7q8J5YwPJ4Xel 83t7Nvs1DSPjCRe gl0hgY8DcInoHrP | |
iEjsfNKwnwbjNgW Ngpol220pejLyM1 BIB312BwlTVlNtt . | |
END MESSAGE. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### Keybase proof | |
I hereby claim: | |
* I am maxim-uvarov on github. | |
* I am maxim_uvarov (https://keybase.io/maxim_uvarov) on keybase. | |
* I have a public key ASDa1AAiTST5fj8TXGkHvzgV9BKGi_iSgEJRip8qxpN0rgo | |
To claim this, I am signing this object: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"title": "select_input_source example (available since Karabiner-Elements 11.1.9)", | |
"rules": [ | |
{ | |
"description": "Change input source to U.S. by left_command, RussianWin by right_command. (available since Karabiner-Elements 11.1.9)", | |
"manipulators": [ | |
{ | |
"type": "basic", | |
"from": { | |
"key_code": "left_command", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"title": "select_input_source example (available since Karabiner-Elements 11.1.9)", | |
"rules": [ | |
{ | |
"description": "Change input source to U.S. by left_command, RussianWin by right_command. (available since Karabiner-Elements 11.1.9)", | |
"manipulators": [ | |
{ | |
"type": "basic", | |
"from": { | |
"key_code": "left_command", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
each try Uri.Parts(_) otherwise [Host=_] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// obfuscastionFun | |
// simple obfuscation function | |
(listToTransform as list)=> | |
let | |
listBufferMain = List.Buffer(listToTransform), | |
removeDuplicates = List.Distinct(listBufferMain), | |
listBuffer = List.Buffer(removeDuplicates), | |
result = List.Transform(listBufferMain, each List.PositionOf(listBuffer, _)) | |
in |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Проект переехал в репозиторий https://github.com/power-bi/KillerDateTableRu |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
Функция, при помощи которой мы забираем из API данные из Яндекс.Метрики | |
Версия 1.12 | |
PQYM = (ids, dimensions, metrics, date1, date2, token, filters, direct_ids) | |
Все значения передаются как text. | |
На выходе получается таблица с запрошенными полями. | |
Домашняя страница: | |
https://github.com/40-02/PQYandexMetrika/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Здесь на скорую руку получаем список метрик и измерений в Яндекс.Метрике | |
let | |
getMetaData = (url as text, TypeOfField as text, ScopeOfField as text) => | |
let | |
Source = Json.Document(Web.Contents( url )), | |
attributes = Source[attributes], | |
#"Table from List" = Table.FromList(attributes, Splitter.SplitByNothing(), null, null, ExtraValues.Error), | |
#"Renamed Columns" = Table.RenameColumns(#"Table from List",{{"Column1", "dimension"}}), | |
#"Expand dimension" = Table.ExpandRecordColumn(#"Renamed Columns", "dimension", {"dim", "name", "allow_filters"}, {"dim", "name", "allow_filters"}), |