🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Exporting grid bin group query to csv or text Postprocessing

User: "satri"
Altair Community Member

Hello

Is there a way to export the query table produced in when grid bin group is created?

See the image bellow

image.png

I can copy the table bellow into excel but it needs lot of data cleaning

image.png

and why does it put it in two rows is there any alternative.

Is there a way tp export the data from query to csv file where everything is in one line?

Find more posts tagged with

Sort by:
1 - 9 of 91
    User: "satri"
    Altair Community Member
    OP
    Updated by satri

    Even if i save the file as a csv file it puts the first coordinate in the second line

    image.png

    I want everything in one line. is there any way to do that?

    Hi Satri,


    It looks like the first line is a description of what is exported, you can omit header info or omit text in the Export Results Data > General dialog box

    image.png
    User: "satri"
    Altair Community Member
    OP

    No i am not exporting with that option. i am creating bins that i am displaying on the console similar to the voidage calculations shown here

    (https://www.youtube.com/watch?v=YzOSjA0sPz4)

    but the output is in the console and i want to export it into a file.

    I do not know how to export results from grid bin group query to a text file

    In the Analyst > File > Export Results Data and under Queries you can select the grid bin group under Selection as shown.

    image.png

    This is the queries tab, under the General tab you can set the data shown in the previous screenshot.


    Regards

    Stephen

    User: "satri"
    Altair Community Member
    OP

    ohh i did not see that new option.

    Thank you for suggesting that.

    User: "satri"
    Altair Community Member
    OP

    Hi I am trying to export a value of mass using this

    I am getting the mass but i want the mass saperated in grid form in the data.

    Is there a way to show that?

    image.png image.png
    User: "satri"
    Altair Community Member
    OP

    Even if i give the option apply to subsections i get this data

    image.png

    How do i know what subsection is what. is there a way to put the centroid of the subsection along with this?

    The bins start in the -X, -Y, -Z corner and step in Z first, then Y then X. You can use Analyst > Selections > Display Options > Edit > Highlight sub-sections to visualise which one is which.

    image.png

    The 'apply to subsections' should export the data per bin.


    Regards

    Stephen

    User: "satri"
    Altair Community Member
    OP

    got it thank you. Please tell me this. i have been considering to use the python postprocessing tool is there any post-processing tool to export data in python deck to computer solid volume fraction.