nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Script extraction

AnthonyS

Good morning

I need a script for extract the .txt datas in a forder and make the average with the datas in the other folder. But the datas must stay in columns. I can tell u a test folder.

Can you help me ? (Sorry for my English)

Best regards,

AnthonyS

Accepted answers

txnelson

The data files in the folder structure that you attached can be read in very easily. The only complexity was in finding the row number the data starts on(61), and the delimiter used to separate the different data fields.(Tab).

To read in the data, go to

File==>Open

Then navigate to the folder where the data are and click on the file you want to open. Only click once on it, and it will display some additional choices

average issue 2.PNG

As seen above select "Data with Preview"

Then click on Open.

You will then be presented with the following screen

average issue.PNG

Change the screen to match the above settings, then click on the "Next" button.

On the next screen that is displayed, you can preview the data that will be input. Click on the "Import" button when you are ready, and the data table will be opened and displayed.

Repeat the same process for to import the second data table.

To accomplish your request for the displaying of the averages, I suggest you use

Cols==>Column Viewer

You appear to be very new to JMP. I strongly suggest that you read the documentation provided with JMP

Help==>Books==>Discovering JMP, Using JMP, Basic Analysis

All comments

txnelson

If you could show what the input folder and a sample of the files in the folder would be very helpful.

AnthonyS

Here's the forlder ans the files.

i need make a average under the preliminary and the repeatability data. And compare the post-stress withe this average but in columns.

thank you very much,

AnthonyS

data (3).zip

txnelson

To read in the data, go to

File==>Open

Then navigate to the folder where the data are and click on the file you want to open. Only click once on it, and it will display some additional choices

average issue 2.PNG

As seen above select "Data with Preview"

Then click on Open.

You will then be presented with the following screen

average issue.PNG

Change the screen to match the above settings, then click on the "Next" button.

On the next screen that is displayed, you can preview the data that will be input. Click on the "Import" button when you are ready, and the data table will be opened and displayed.

Repeat the same process for to import the second data table.

To accomplish your request for the displaying of the averages, I suggest you use

Cols==>Column Viewer

You appear to be very new to JMP. I strongly suggest that you read the documentation provided with JMP

Help==>Books==>Discovering JMP, Using JMP, Basic Analysis

AnthonyS

Sorry i haven't explainned myself well,

i need a script for extract all files in the sub folder and concatain this in the jmp data table like the script an attachment "Script_Base".

And after i need create new culumns "AVERAGE_VBIAS" , calculate the average under the ''MEAN_VBIAS_MEAS'' preliminary and repeatability:

example:

avarage under preliminary and repeatability ''MEAN_VBIAS_MEAS'' by "BRIDGE_NUMBER" by "SAMPLE_ID"

And also for the columns "MEAN_VOUT_MEAS" and "MEAN_BRIDGE_RATIO".

Best regards,

Anthony

DATA.zip