cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
%3CLINGO-SUB%20id%3D%22lingo-sub-348968%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E4%B8%8D%E4%BD%BF%E7%94%A8%20for%20%E5%BE%AA%E7%8E%AF%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-348968%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%91%E6%83%B3%E8%A6%81%E4%B8%80%E7%A7%8D%E5%9C%A8%E4%B8%8D%E4%BD%BF%E7%94%A8%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%E7%9A%84%E6%96%B9%E6%B3%95%E3%80%82%20%E4%B9%9F%E5%B0%B1%E6%98%AF%E8%AF%B4%EF%BC%8C%E6%9F%90%E4%BA%9B%E5%87%BD%E6%95%B0%EF%BC%88%E4%BE%8B%E5%A6%82%EF%BC%8C%E7%A7%B0%E4%B8%BA%E2%80%9CListtranspose%E2%80%9D%EF%BC%89%E5%8F%AF%E4%BB%A5%E7%BF%BB%E8%BD%AC%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%E7%9A%84%E2%80%9C%E8%A1%8C%E2%80%9D%E5%92%8C%E2%80%9C%E5%88%97%E2%80%9D%EF%BC%8C%E5%A6%82%E4%B8%8B%E6%89%80%E7%A4%BA%EF%BC%9A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Elistlist%20%3D%20%7B%7B%22cat%22%2C%20%22dog%22%2C%20%22mouse%22%7D%2C%20%7B%22meow%22%2C%20%22bark%22%2C%20%22squeak%22%7D%7D%3B%0Atranlist%20%3D%20Listtranspose(listlist)%3B%0AShow(tranlist)%3B%0A%0A%2F*Result%3A%0A%7B%7B%22cat%22%2C%20%22meow%22%7D%2C%20%7B%22dog%22%2C%20%22bark%22%7D%2C%20%7B%22mouse%22%2C%20%22squeak%7D%7D%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E6%9B%BF%E4%BB%A3%E5%AE%9E%E7%8E%B0%E5%8F%AF%E8%83%BD%E7%B1%BB%E4%BC%BC%E4%BA%8E%EF%BC%9A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Elistlist%20%3D%20%7B%7B%22cat%22%2C%20%22dog%22%2C%20%22mouse%22%7D%2C%20%7B%22meow%22%2C%20%22bark%22%2C%20%22squeak%22%7D%7D%3B%0Anr%20%3D%20NItems(listlist)%3B%0Acol1%20%3D%20listlist%5B1%3A%3Anr%5D%5B1%5D%3B%0Acol2%20%3D%20listlist%5B1%3A%3Anr%5D%5B2%5D%3B%0Acol3%20%3D%20listlist%5B1%3A%3Anr%5D%5B3%5D%3B%0Atranslist%20%3D%20EvalList(%7Bcol1%2C%20col2%2C%20col3%7D)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E6%88%91%E6%9B%B4%E5%96%9C%E6%AC%A2%E5%90%8E%E4%B8%80%E7%A7%8D%E5%AE%9E%E7%8E%B0%EF%BC%8C%E5%9B%A0%E4%B8%BA%E6%88%91%E5%8F%AF%E8%83%BD%E5%8F%AA%E9%9C%80%E8%A6%81%E8%BD%AC%E7%BD%AE%E2%80%9C%E5%88%97%E2%80%9D%E7%9A%84%E5%AD%90%E9%9B%86%EF%BC%8C%E8%80%8C%E4%B8%8D%E6%98%AF%E6%95%B4%E4%B8%AA%E5%88%97%E8%A1%A8%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E5%BD%93%E7%84%B6%EF%BC%8C%E8%BF%99%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%20For%20%E5%BE%AA%E7%8E%AF%E6%9D%A5%E5%AE%8C%E6%88%90%EF%BC%8C%E4%BD%86%E8%A6%81%E6%B1%82%E8%BF%99%E6%A0%B7%E5%81%9A%E7%9A%84%E5%8E%9F%E5%9B%A0%E6%98%AF%20For%20%E5%BE%AA%E7%8E%AF%E5%8F%AF%E8%83%BD%E5%BE%88%E6%85%A2%E3%80%82%20%E6%88%91%E5%A4%84%E7%90%86%E5%A4%A7%E5%9D%97%E6%96%87%E6%9C%AC%EF%BC%8C%E6%88%91%E7%9B%B8%E4%BF%A1%E8%BF%99%E5%B0%86%E5%B8%AE%E5%8A%A9%E6%88%91%E5%A4%A7%E5%A4%A7%E5%8A%A0%E5%BF%AB%E9%80%9F%E5%BA%A6%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E5%BD%92%E5%8A%9F%E4%BA%8E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2610%22%20target%3D%22_blank%22%3E%40vince_faller%3C%2FA%3E%E6%9C%80%E5%88%9D%E9%97%AE%E8%BF%99%E4%B8%AA%E9%97%AE%E9%A2%98%E3%80%82%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FTranspose-List-of-Lists-without-a-for-loop%2Fm-p%2F348968%23U348968%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%E4%B8%8D%E4%BD%BF%E7%94%A8%20for%20%E5%BE%AA%E7%8E%AF%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-348968%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8A%A8%E5%8C%96%E5%92%8C%E8%84%9A%E6%9C%AC%E7%BC%96%E5%86%99%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-353160%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-353160%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%86%8D%E6%83%B3%E4%B8%80%E6%83%B3%E8%BF%99%E4%B8%AA%E9%97%AE%E9%A2%98%E3%80%82%E6%88%91%E4%BB%8D%E7%84%B6%E6%97%A0%E6%B3%95%E5%87%BB%E8%B4%A5%20for%20%E5%BE%AA%E7%8E%AF%EF%BC%8C%E4%BD%86%E6%88%91%E6%83%B3%E6%88%91%E4%BC%9A%E6%8A%8A%E5%AE%83%E5%86%99%E4%B8%8B%E6%9D%A5%EF%BC%8C%E4%BB%A5%E9%98%B2%E5%AE%83%E5%AF%B9%E4%BB%BB%E4%BD%95%E4%BA%BA%E6%9C%89%E5%B8%AE%E5%8A%A9%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20make%20a%20blank%20data%20table%20with%20the%20right%20shape%0Adt%20%3D%20As%20Table(J(nr%2C%20nc%2C%20.)%2C%20%26lt%3B%3CPRIVATE%3E%3C%2FPRIVATE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-352364%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352364%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F982%22%20target%3D%22_blank%22%3E%40Craige_Hales%3C%2FA%3E%E6%84%9F%E8%B0%A2%E5%85%8B%E9%9B%B7%E6%A0%BC%E7%9A%84%E6%B7%B1%E5%88%BB%E8%A7%81%E8%A7%A3%E3%80%82%20%E6%88%91%E5%90%8C%E6%84%8F%EF%BC%8C%E6%88%91%E5%AF%B9%20for%20%E5%BE%AA%E7%8E%AF%E4%B8%8E%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%E6%96%B9%E6%B3%95%E8%BF%9B%E8%A1%8C%E4%BA%86%E9%80%9F%E5%BA%A6%E6%B5%8B%E8%AF%95%EF%BC%8C%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%E9%80%9F%E5%BA%A6%E8%A6%81%E6%85%A2%E5%BE%97%E5%A4%9A%E3%80%82%20%E6%88%91%E7%9A%84%E5%88%97%E8%A1%A8%E6%95%B0%E7%BB%84%E4%B8%BA%20718r%20x%2014182c%EF%BC%8C%E5%9B%A0%E6%AD%A4%E8%B6%85%E8%BF%87%201000%20%E4%B8%87%E4%B8%AA%E5%85%83%E7%B4%A0%E3%80%82%20%E6%88%91%E8%BF%90%E8%A1%8C%E8%84%9A%E6%9C%AC%E7%BA%A6%2010%20%E5%88%86%E9%92%9F%EF%BC%8C%E4%BD%86%E6%93%8D%E4%BD%9C%E6%9C%AA%E5%AE%8C%E6%88%90%E3%80%82%20%E8%BF%99%E4%BC%BC%E4%B9%8E%E6%AF%94%E4%B8%8A%E9%9D%A2%E7%9A%84%E6%95%B0%E6%8D%AE%E9%A2%84%E6%B5%8B%E7%9A%84%E8%A6%81%E6%85%A2%E4%B8%80%E7%82%B9%EF%BC%8C%E4%BD%86%E6%98%AF%E8%A6%81%E8%80%83%E8%99%91%E7%9A%84%E5%8F%98%E9%87%8F%E5%A4%AA%E5%A4%9A%EF%BC%88%E4%BE%8B%E5%A6%82%E8%AE%A1%E7%AE%97%E6%9C%BA%E7%B3%BB%E7%BB%9F%E3%80%81%E5%88%97%E4%B8%8E%E8%A1%8C%E7%9A%84%E6%AF%94%E7%8E%87%EF%BC%9F%EF%BC%89%E3%80%82%20%E5%AF%B9%E4%BA%8E%E5%90%8C%E4%B8%80%E4%B8%AA%E8%A1%A8%EF%BC%8CFor%20%E5%BE%AA%E7%8E%AF%E9%80%9F%E5%BA%A6%E8%A6%81%E5%BF%AB%E5%BE%97%E5%A4%9A%EF%BC%8C%E7%BA%A6%E4%B8%BA%2010.1%20%E7%A7%92%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E4%BD%86%E4%BB%8D%E7%84%B6%E6%AF%94%E6%88%91%E6%83%B3%E8%A6%81%E7%9A%84%E6%85%A2%E3%80%82%20%E5%A6%82%E6%9E%9C%E6%9C%89%E4%B8%80%E4%B8%AA%20JMP%20%E5%87%BD%E6%95%B0%E5%8F%AF%E4%BB%A5%E5%9C%A8%E5%86%85%E9%83%A8%E6%89%A7%E8%A1%8C%E6%AD%A4%E6%93%8D%E4%BD%9C%EF%BC%8C%E9%82%A3%E5%B0%B1%E5%A4%AA%E5%A5%BD%E4%BA%86%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-350400%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-350400%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%86%E6%98%AF%EF%BC%8C%E7%BB%8F%E8%BF%87%E4%B8%80%E4%BA%9B%E6%B5%8B%E8%AF%95%EF%BC%8C%E6%88%91%E8%AE%A4%E4%B8%BA%E7%AE%80%E5%8D%95%E7%9A%84%E5%B5%8C%E5%A5%97%E5%BE%AA%E7%8E%AF%E5%B0%86%E6%AF%94%E4%BB%BB%E4%BD%95%E5%85%B6%E4%BB%96%E5%9F%BA%E4%BA%8E%20JSL%20%E7%9A%84%E6%96%B9%E6%B3%95%E6%9B%B4%E5%BF%AB%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20result%20%3D%20%7B%7D%3B%0A%20for(%20c%20%3D%201%2C%20c%20%26lt%3B%3D%20nc%2C%20c%20%2B%3D%201%2C%0A%20%20thisrow%20%3D%20%7B%7D%3B%20%2F%2F%20build%20a%20row%20from%20a%20column%0A%20%20for(%20r%20%3D%201%2C%20r%20%26lt%3B%3D%20nr%2C%20r%20%2B%3D%201%2C%0A%20%20%20thisrow%5Br%5D%20%3D%20testList%5Br%5D%5Bc%5D%3B%0A%20%20)%3B%0A%20%20result%5Bc%5D%20%3D%20thisrow%3B%0A%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5080%22%20target%3D%22_blank%22%3E%40%E5%94%90%E9%BA%A6%E8%80%83%E9%A9%AC%E5%85%8B%3C%2FA%3E-%20%E6%8C%91%E6%88%98%EF%BC%81%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22The%20blue-line%20for-loop%20is%20consistently%20better.%20The%20purple%20JSON-table%20might%20overtake%20it%2C%20but%20I'm%20running%20out%20of%20memory.%20The%20parallel-assign%20trick%20begins%20to%20fail%20for%20large%20numbers.%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22The%20blue-line%20for-loop%20is%20consistently%20better.%20The%20purple%20JSON-table%20might%20overtake%20it%2C%20but%20I'm%20running%20out%20of%20memory.%20The%20parallel-assign%20trick%20begins%20to%20fail%20for%20large%20numbers.%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22The%20blue-line%20for-loop%20is%20consistently%20better.%20The%20purple%20JSON-table%20might%20overtake%20it%2C%20but%20I'm%20running%20out%20of%20memory.%20The%20parallel-assign%20trick%20begins%20to%20fail%20for%20large%20numbers.%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F29503iBDB6FC8699FF6D9A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22The%20blue-line%20for-loop%20is%20consistently%20better.%20The%20purple%20JSON-table%20might%20overtake%20it%2C%20but%20I'm%20running%20out%20of%20memory.%20The%20parallel-assign%20trick%20begins%20to%20fail%20for%20large%20numbers.%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThe%20blue-line%20for-loop%20is%20consistently%20better.%20The%20purple%20JSON-table%20might%20overtake%20it%2C%20but%20I'm%20running%20out%20of%20memory.%20The%20parallel-assign%20trick%20begins%20to%20fail%20for%20large%20numbers.%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThe%20blue-line%20for-loop%20is%20consistently%20better.%20The%20purple%20JSON-table%20might%20overtake%20it%2C%20but%20I'm%20running%20out%20of%20memory.%20The%20parallel-assign%20trick%20begins%20to%20fail%20for%20large%20numbers.%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E%E8%93%9D%E7%BA%BF%20for%20%E5%BE%AA%E7%8E%AF%E5%A7%8B%E7%BB%88%E6%9B%B4%E5%A5%BD%E3%80%82%20%E7%B4%AB%E8%89%B2%20JSON%20%E8%A1%A8%E5%8F%AF%E8%83%BD%E4%BC%9A%E8%B6%85%E8%B6%8A%E5%AE%83%EF%BC%8C%E4%BD%86%E6%88%91%E7%9A%84%E5%86%85%E5%AD%98%E4%B8%8D%E8%B6%B3%E4%BA%86%E3%80%82%20%E5%AF%B9%E4%BA%8E%E5%A4%A7%E9%87%8F%E6%95%B0%E6%8D%AE%EF%BC%8C%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%E6%8A%80%E5%B7%A7%E5%BC%80%E5%A7%8B%E5%A4%B1%E6%95%88%E3%80%82%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%E5%8F%AF%E8%83%BD%E5%A7%8B%E7%BB%88%E4%BC%9A%E9%98%BB%E5%A1%9E%E7%BA%BF%E7%A8%8B%E4%B9%8B%E9%97%B4%E7%9A%84%E5%86%B2%E7%AA%81%E3%80%82%20%E5%AE%83%E9%A6%96%E5%85%88%E5%87%BB%E8%B4%A5%E4%BA%86%20json%20%E6%95%B0%E6%8D%AE%E8%A1%A8%EF%BC%8C%E5%9B%A0%E4%B8%BA%E4%B8%A4%E8%80%85%E4%B9%8B%E9%97%B4%E7%9A%84%E5%BC%80%E9%94%80%E4%B8%8D%E5%90%8C%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-350372%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-350372%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%98%AF%E7%9A%84%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%9C%89%E6%9B%B4%E5%A4%9A%E7%9A%84%E5%88%97%E8%A1%A8%E6%93%8D%E4%BD%9C%E5%87%BD%E6%95%B0%E5%B0%B1%E5%A5%BD%E4%BA%86%E3%80%82%20%E6%88%91%E6%83%B3%E4%B8%8D%E5%87%BA%E4%B8%80%E4%B8%AA%E5%A5%BD%E7%9A%84%E6%88%96%E5%BF%AB%E9%80%9F%E7%9A%84%E6%96%B9%E6%B3%95%EF%BC%8C%E4%BD%86%E7%8E%A9%E4%BA%86%E4%B8%80%E4%B8%8B%E4%B9%8B%E5%90%8E%E6%83%B3%E5%87%BA%E4%BA%86%E8%BF%99%E4%B8%AA%E3%80%82%20%E5%AE%83%E9%9C%80%E8%A6%81%20JMP%2015%EF%BC%8C%E5%9C%A8%2014%20%E4%B8%AD%E5%A4%B1%E8%B4%A5%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Elist%20%3D%20%7B%7B%22lion%22%2C%20%22tiger%22%2C%20%22puma%22%7D%2C%20%7B%22lamp%22%2C%20%22torch%22%2C%20%22pharos%22%7D%2C%20%7B%22lark%22%2C%20%22toucan%22%2C%20%22pigeon%22%7D%2C%20%7B%22lawn%22%2C%20%22terrace%22%2C%20%22patio%22%7D%7D%3B%0Ajlist%20%3D%20As%20JSON%20Expr(%20list%20)%3B%0Adt1%20%3D%20JSON%20To%20Data%20Table(%20jlist%2C%20invisible(1)%20)%3B%0Adt1%20%26lt%3B%26lt%3B%20New%20Column(%20%22row%22%2C%20numeric%2C%20setvalues(%201%20%2B%20Floor(%20(0%20%3A%3A%20(N%20Rows(%20dt1%20)%20-%201))%20%2F%20N%20Items(%20list%5B1%5D%20)%20)%20)%20)%3B%0Adt2%20%3D%20dt1%20%26lt%3B%26lt%3B%20Split(%20Split%20By(%20%3Arow%20)%2C%20Split(%20column(dt1%2C1)%20)%2C%20Sort%20by%20Column%20Property%2C%20invisible(1)%20)%3B%0AClose(%20dt1%2C%20nosave%20)%3B%0Atransposed%20%3D%20dt2%5B0%2C%200%5D%3B%0AClose(%20dt2%2C%20nosave%20)%3B%0AShow(%20list%2C%20transposed%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CSTRONG%3Elist%20%3D%20%7B%7B%22lion%22%2C%20%22tiger%22%2C%20%22puma%22%7D%2C%20%7B%22lamp%22%2C%20%22torch%22%2C%20%22pharos%22%7D%2C%20%7B%22lark%22%2C%20%22toucan%22%2C%20%22pigeon%22%7D%2C%20%7B%22lawn%22%2C%20%E2%80%9C%E9%9C%B2%E5%8F%B0%E2%80%9D%E3%80%81%E2%80%9C%E5%A4%A9%E4%BA%95%E2%80%9D%7D%7D%EF%BC%9B%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%E8%BD%AC%E7%BD%AE%20%3D%20%7B%7B%22%E7%8B%AE%E5%AD%90%22%2C%20%22%E7%81%AF%22%2C%20%22%E4%BA%91%E9%9B%80%22%2C%20%22%E8%8D%89%E5%9D%AA%22%7D%2C%20%7B%22%E8%80%81%E8%99%8E%22%2C%20%22%E7%81%AB%E7%82%AC%22%2C%20%22%E5%B7%A8%E5%98%B4%E9%B8%9F%22%2C%20%22%E9%9C%B2%E5%8F%B0%22%7D%2C%20%7B%22%E7%BE%8E%E6%B4%B2%E7%8B%AE%22%2C%20%22%3CA%20href%3D%22https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FLighthouse_of_Alexandria%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%E6%B3%95%E7%BD%97%E6%96%AF%3C%2FA%3E%22%2C%20%22%E9%B8%BD%E5%AD%90%22%2C%20%22%E5%BA%AD%E9%99%A2%22%7D%7D%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%E5%8F%96%E6%B6%88%E9%9A%90%E8%97%8F%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%BB%A5%E6%9F%A5%E7%9C%8B%E5%AE%83%E6%AD%A3%E5%9C%A8%E5%81%9A%E4%BB%80%E4%B9%88%E3%80%82%20%E7%9C%9F%E6%AD%A3%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%E5%BA%94%E8%AF%A5%E5%A4%84%E7%90%86%E9%95%BF%E5%BA%A6%E4%B8%8D%E7%AD%89%E7%9A%84%E8%A1%8C%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-349949%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-349949%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F982%22%20target%3D%22_blank%22%3E%40Craige_Hales%3C%2FA%3E%E5%86%99%E4%BA%86%E4%B8%80%E4%B8%AA%E6%88%91%E7%BB%8F%E5%B8%B8%E4%BD%BF%E7%94%A8%E7%9A%84%E5%BE%88%E5%A5%BD%E7%9A%84%E8%A7%A3%E9%87%8A%E3%80%82%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FMultithreading-troubleshooting-using-Parallel-Assign%2Fm-p%2F230563%23U230563%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%E4%BD%BF%E7%94%A8%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%E8%BF%9B%E8%A1%8C%E5%A4%9A%E7%BA%BF%E7%A8%8B%E6%95%85%E9%9A%9C%E6%8E%92%E9%99%A4%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-349926%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-349926%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2610%22%20target%3D%22_blank%22%3E%40vince_faller%3C%2FA%3E%3C%2FP%3E%3CP%3E%E5%A4%B4%E8%84%91%3D%3D%E7%82%B8%E4%BA%86%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E4%BB%A5%E5%89%8D%E4%BB%8E%E6%9C%AA%E5%90%AC%E8%AF%B4%E8%BF%87%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%E5%8A%9F%E8%83%BD%E3%80%82%20%E6%88%91%E5%B0%9D%E8%AF%95%E8%BF%87%E8%BF%99%E4%B8%AA%EF%BC%8C%E6%98%AF%E7%9A%84%EF%BC%8C%E5%AE%83%E6%9C%89%E6%95%88%E3%80%82%20%E5%B0%BD%E7%AE%A1%E6%88%91%E6%AD%A3%E5%9C%A8%E5%A4%84%E7%90%86%E5%AD%97%E7%AC%A6%E4%B8%B2%EF%BC%8C%E5%B9%B6%E4%B8%94%E8%BF%99%E5%9C%A8%E6%8A%80%E6%9C%AF%E4%B8%8A%E6%98%AF%E4%B8%80%E4%B8%AA%E7%9F%A9%E9%98%B5%E5%87%BD%E6%95%B0%EF%BC%8C%E4%BD%86%E5%AE%83%E5%B9%B6%E4%B8%8D%E5%85%B3%E5%BF%83%E3%80%82%20%E7%8E%A9%E8%BF%99%E4%B8%AA%E4%BC%9A%E5%BE%88%E6%9C%89%E8%B6%A3%EF%BC%8C%E7%9C%8B%E7%9C%8B%E5%AE%83%E6%98%AF%E5%90%A6%E6%AF%94%20for%20%E5%BE%AA%E7%8E%AF%E6%9B%B4%E5%BF%AB%E3%80%82%20%E4%B8%80%E6%97%A6%E6%88%91%E7%9F%A5%E9%81%93%EF%BC%8C%E6%88%91%E4%BC%9A%E5%B0%9D%E8%AF%95%E5%9C%A8%E8%BF%99%E9%87%8C%E6%9B%B4%E6%96%B0%E3%80%82%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%B0%A2%E8%B0%A2%E4%BD%A0%E7%9A%84%E4%B8%BB%E6%84%8F%EF%BC%81%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-349007%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E6%B2%A1%E6%9C%89%20for%20%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%83%85%E5%86%B5%E4%B8%8B%E8%BD%AC%E7%BD%AE%E5%88%97%E8%A1%A8%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-349007%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%91%E5%8F%91%E8%AA%93%E6%88%91%E7%9C%8B%E5%88%B0%E6%9C%89%E4%BA%BA%E5%81%9A%E4%BA%86%E7%B1%BB%E4%BC%BC%E7%9A%84%E4%BA%8B%E6%83%85%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%7B%22cat%22%2C%20%22dog%22%2C%20%22mouse%22%2C%20%22meow%22%2C%20%22bark%22%2C%20%22squeak%22%7D%5B%5B1%201%2C%201%201%5D%5D%0A%2F%2F%20and%20had%20it%20return%0A%7B%7B%22cat%22%2C%20%22cat%22%7D%2C%20%7B%22cat%22%2C%20%22cat%22%7D%7D%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E5%9C%A8%E5%8F%91%E7%8E%B0%E6%BC%94%E8%AE%B2%E6%9C%9F%E9%97%B4%EF%BC%8C%E4%BD%86%E6%88%91%E4%BB%8E%E6%9C%AA%E8%83%BD%E5%A4%9F%E9%87%8D%E6%96%B0%E5%88%9B%E5%BB%BA%E5%AE%83%E3%80%82%E8%BF%99%E4%B8%80%E5%88%87%E9%83%BD%E5%8F%AF%E8%83%BD%E6%98%AF%E4%B8%80%E5%9C%BA%E6%A2%A6%E5%90%97%EF%BC%9F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E5%A6%82%E6%9E%9C%E6%88%91%E6%B2%A1%E8%AE%B0%E9%94%99%E7%9A%84%E8%AF%9D%EF%BC%8C%E4%BB%96%E4%BB%AC%E4%BB%A5%E6%9F%90%E7%A7%8D%E6%96%B9%E5%BC%8F%E4%BB%8E%E4%B8%80%E4%B8%AA%E5%B9%B3%E9%9D%A2%E5%88%97%E8%A1%A8%E4%B8%AD%E5%83%8F%E8%BF%99%E6%A0%B7%E4%B8%80%E8%A1%8C%E5%BD%A2%E6%88%90%E4%BA%86%E4%B8%80%E4%B8%AA%E6%96%B0%E5%88%97%E8%A1%A8%E3%80%82%E5%BA%94%E8%AF%A5%E6%98%AF%E6%88%91%E6%B2%A1%E8%AE%B0%E9%94%99%E5%90%A7%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E8%AF%9D%E8%99%BD%E8%BF%99%E4%B9%88%E8%AF%B4%EF%BC%8C%E4%BD%A0%E5%8F%AF%E8%83%BD%E5%8F%AF%E4%BB%A5%E9%9D%9E%E5%B8%B8%E5%BF%AB%E5%9C%B0%E8%BF%9B%E8%A1%8C%E5%B9%B6%E8%A1%8C%E5%88%86%E9%85%8D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Enames%20default%20to%20here(1)%3B%0Alistlist%20%3D%20%7B%7B%22cat%22%2C%20%22dog%22%2C%20%22mouse%22%7D%2C%20%7B%22meow%22%2C%20%22bark%22%2C%20%22squeak%22%7D%7D%3B%0Am%20%3D%20J(nc%2C%20nr%2C%20-1)%3B%0A%3A%3Atrans_list%20%3D%20Aslist(m)%3B%0AParallel%20Assign(%7Bl%20%3D%20listlist%7D%2C%20%0A%20m%5Ba%2C%20b%5D%20%3D%20(%0A%20%20%3A%3Atrans_list%5Ba%5D%5Bb%5D%20%3D%20l%5Bb%5D%5Ba%5D%3B%0A%20)%0A)%3B%0Ashow(%3A%3Atrans_list)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Transpose List of Lists without a for loop

I would like to have a method to transpose a list of lists without using a for loop.  That is, some function (call it "Listtranspose" for instance) that flips the "rows" and "columns" of a list of lists, like this:

 

listlist = {{"cat", "dog", "mouse"}, {"meow", "bark", "squeak"}};
tranlist = Listtranspose(listlist);
Show(tranlist);

/*Result:
{{"cat", "meow"}, {"dog", "bark"}, {"mouse", "squeak}}

An alternate implementation could be something like:

 

 

listlist = {{"cat", "dog", "mouse"}, {"meow", "bark", "squeak"}};
nr = NItems(listlist);
col1 = listlist[1::nr][1];
col2 = listlist[1::nr][2];
col3 = listlist[1::nr][3];
translist = EvalList({col1, col2, col3});

I kind of like the latter implementation better as I might only need to transpose just a subset of "columns", not the entire list.

 

 

Of course, this can be done using a For Loop, but the reason for asking for this is that For Loops can be slow.  I work with large blocks of text and I believe this would help speed things up greatly for me.

 

Credit to @vince_faller for asking this originally. Transpose List of Lists without a for loop 

 

 

14 Comments
vince_faller
Super User (Alumni)

Sorry, I was saying  that I was lazy and selfish.  I had an angel emoji but it didn't come through.  Very sorry.  

hogi
Level XIII

hogi_0-1725644718314.png

The disadvantage of not having Emojis in the community ; )

hogi
Level XIII

Parallel Assign (as 2-dimensional for loop) has no chance to win against the 1D-For Loop
(... or @vince_faller 's approach via data table manipulations)

winner on my system:  DataTable!

hogi_1-1725636479748.png

hogi
Level XIII

with just a single vote since 2021, I think the is little chance for 

Listtranspose(listlist);

 

If users found this wish, please also take the time to look at Insert Into: Flatten(0|1) - and vote