KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums kdb+ KX Developer Visual Inspector Multiple X points Re: KX Developer Visual Inspector Multiple X points

  • rocuinneagain

    Member
    October 6, 2021 at 12:00 am

    One option would be to unpivot the table using a helper function

     

    /tab : the table to operate on 
    /baseCols : the columns not to unpivot 
    /pivotCols : the columns which you wish to unpivot 
    /kCol : the key name for unpivoted data 
    /vCol : the value name for unpivoted data 
    unpivot:{[tab;baseCols;pivotCols;kCol;vCol] 
        base:?[tab;();0b;{x!x}(),baseCols]; 
        newCols:{[k;v;t;p] flip (k;v)!(count[t]#p;t p)}[kCol;vCol;tab] each pivotCols; 
        baseCols xasc raze {[b;n] b,'n}[base] each newCols } 
    
    unpivot[;`time;`price`pricev2;`priceType;`price] table 
    time       priceType price 
    ---------------------------- 
    00:00:00.002 price   6.33 
    00:00:00.002 pricev2 6.32 
    00:00:01.001 price   4.05 
    00:00:01.001 pricev2 4.05 
    00:00:26.808 price   4.05 
    00:00:26.808 pricev2 5.07 
    00:00:27.002 price   5.12 
    00:00:27.002 pricev2 5.12 
    00:00:28.002 price   2.61 
    00:00:28.002 pricev2 2.61 
    00:00:29.002 price   4.61 
    00:00:29.002 pricev2 4.47 
    00:00:30.001 price   4.9 
    00:00:30.001 pricev2 4.47 
    00:00:31.000 price   4.64 
    00:00:31.000 pricev2 4.77 
    00:00:32.000 price   2.37 
    00:00:32.000 pricev2 4.87 
    00:00:33.000 price   3.75 
    00:00:33.000 pricev2 2.7

     

     

     

    Then you can set the options to graph the lines