maxim-uvarov

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

maxim-uvarov

// Здесь на скорую руку получаем список метрик и измерений в Яндекс.Метрике
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"}),

maxim-uvarov

/*
     Функция, при помощи которой мы забираем из API данные из Яндекс.Метрики
     Версия 1.12

     PQYM = (ids, dimensions, metrics, date1, date2, token, filters, direct_ids)
     Все значения передаются как text. 
     На выходе получается таблица с запрошенными полями.  

     Домашняя страница: 
     https://github.com/40-02/PQYandexMetrika/

maxim-uvarov

Проект переехал в репозиторий https://github.com/power-bi/KillerDateTableRu

maxim-uvarov

// 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}}),

maxim-uvarov

// 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

maxim-uvarov

each try Uri.Parts(_) otherwise [Host=_]

maxim-uvarov

{
  "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",

maxim-uvarov

{
  "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",

maxim-uvarov

### 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: