https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772935#M15396 <P>Is it possible to change this automatically order? I need the order I see in my list.<BR />And I need the detailed data, because I want to export all the rows in my data list.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="formated" style="width: 471px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/64498i16B30BC80CEF4699/image-size/large?v=v2&amp;px=999" role="button" title="export_data_form.png" alt="formated" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">formated</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="details" style="width: 455px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/64499iE7AB418B004D5A34/image-size/large?v=v2&amp;px=999" role="button" title="export_data_detail.png" alt="details" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">details</span></span></P> Fri, 08 Oct 2021 05:29:18 GMT Muandre 2021-10-08T05:29:18Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772631#M15387 <P><SPAN>Hi,</SPAN></P> <P>I want to export my data from a <SPAN>list table&nbsp;</SPAN>to excel. When I export&nbsp;<SPAN>detailed data, they are sorted in alphabetical order, not in the specific order that I want. How can I change that?</SPAN></P> <P><SPAN>My SAS version:</SPAN></P> <DIV id="__popover29-productName" class="aboutRow sapMFlexBox sapMFlexBoxAlignContentStretch sapMFlexBoxAlignItemsStart sapMFlexBoxBGTransparent sapMFlexBoxJustifyStart sapMFlexBoxWrapNoWrap sapMFlexItem sapMFlexItemAlignAuto sapMHBox" data-sap-ui="__popover29-productName"> <DIV id="__data13640" class="sapMFlexBoxBGTransparent sapMFlexItem sapMFlexItemAlignAuto"><SPAN class="aboutSecondCol sapMText sapMTextMaxWidth sasMText" data-sap-ui="__text519">SAS® Visual Analytics,&nbsp;</SPAN><SPAN style="font-family: inherit;">Release:&nbsp;</SPAN><SPAN style="font-family: inherit;">8.5.1</SPAN></DIV> </DIV> <DIV id="__popover29-viyaRelease" class="aboutRow sapMFlexBox sapMFlexBoxAlignContentStretch sapMFlexBoxAlignItemsStart sapMFlexBoxBGTransparent sapMFlexBoxJustifyStart sapMFlexBoxWrapNoWrap sapMFlexItem sapMFlexItemAlignAuto sapMHBox" data-sap-ui="__popover29-viyaRelease"> <DIV id="__data13643" class="sapMFlexBoxBGTransparent sapMFlexItem sapMFlexItemAlignAuto"><SPAN class="aboutFirstCol sapMText sapMTextMaxWidth sasMText" data-sap-ui="__text522">SAS® Viya® Release:&nbsp;</SPAN><SPAN class="aboutSecondCol sapMText sapMTextMaxWidth sasMText sapMTextBreakWord" data-sap-ui="__text523">V.03.05</SPAN></DIV> <DIV class="sapMFlexBoxBGTransparent sapMFlexItem sapMFlexItemAlignAuto">&nbsp;</DIV> <DIV class="sapMFlexBoxBGTransparent sapMFlexItem sapMFlexItemAlignAuto"><SPAN class="aboutSecondCol sapMText sapMTextMaxWidth sasMText sapMTextBreakWord" data-sap-ui="__text523">Thank you!</SPAN></DIV> <DIV class="sapMFlexBoxBGTransparent sapMFlexItem sapMFlexItemAlignAuto"><SPAN class="aboutSecondCol sapMText sapMTextMaxWidth sasMText sapMTextBreakWord" data-sap-ui="__text523">Muandre</SPAN></DIV> </DIV> Thu, 07 Oct 2021 06:07:17 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772631#M15387 Muandre 2021-10-07T06:07:17Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772720#M15391 <P>When you export detailed data, the columns are in alphabetical order. They are automatically placed in that order when the additional columns are added to the list.&nbsp;</P> Thu, 07 Oct 2021 13:22:31 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772720#M15391 Madelyn_SAS 2021-10-07T13:22:31Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772737#M15393 <P>I think to order you see in VA is respected as well when exporting to excel.</P> <P>Have in mind that you can order (toggle by descending | ascending clicking on the column) by several columns. Get this activated by holding ctrl while clicking additional columns to be sorted for.</P> Thu, 07 Oct 2021 14:01:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772737#M15393 acordes 2021-10-07T14:01:03Z https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772935#M15396 <P>Is it possible to change this automatically order? I need the order I see in my list.<BR />And I need the detailed data, because I want to export all the rows in my data list.<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="formated" style="width: 471px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/64498i16B30BC80CEF4699/image-size/large?v=v2&amp;px=999" role="button" title="export_data_form.png" alt="formated" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">formated</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="details" style="width: 455px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/64499iE7AB418B004D5A34/image-size/large?v=v2&amp;px=999" role="button" title="export_data_detail.png" alt="details" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">details</span></span></P> Fri, 08 Oct 2021 05:29:18 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-VIYA-VA-export-data-to-excel-specific-order-in-details/m-p/772935#M15396 Muandre 2021-10-08T05:29:18Z