https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876864#M103986 <P>please note that any processing steps (new columns, formatting, grouping)&nbsp; will be deleted during the "update".<BR />For "new columns", there is a warning - the other settings get deleted without a warning.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1748454737513.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/76342iD68EB1BF95047BFE/image-size/medium?v=v2&amp;px=400" role="button" title="hogi_0-1748454737513.png" alt="hogi_0-1748454737513.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>there are several posts in the wish list to optimize the behavior.</P> <P><LI-MESSAGE title="Join, Concat and Update" uid="555726" url="https://community.jmp.com/t5/JMP-Wish-List/Join-Concat-and-Update/m-p/555726#U555726" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> <P><LI-MESSAGE title="universal &amp;quot;update&amp;quot; button for imported data" uid="467972" url="https://community.jmp.com/t5/JMP-Wish-List/universal-quot-update-quot-button-for-imported-data/m-p/467972#U467972" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> <P>Please support them if you need functionality beyond what is possible at the moment in JMP.</P> Wed, 28 May 2025 17:52:48 GMT hogi 2025-05-28T17:52:48Z https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876711#M103976 <P>Can JMP data table be updated from same excel file with new input only</P> Wed, 28 May 2025 05:55:48 GMT https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876711#M103976 jadeyan 2025-05-28T05:55:48Z https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876725#M103977 <P>I have simple excel file</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1748413783632.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/76291iE3CEB6605A232C49/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1748413783632.png" alt="jthi_1-1748413783632.png" /></span></P> <P>&nbsp;</P> <P>imported to JMP</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1748413774798.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/76290i18D6A9A3C7F32936/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1748413774798.png" alt="jthi_0-1748413774798.png" /></span></P> <P>When new lines get added</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_2-1748413800114.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/76292i7D465C7B8548BC27/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_2-1748413800114.png" alt="jthi_2-1748413800114.png" /></span></P> <P>I can use Update Table table script to <STRONG>update</STRONG> the data. It might be that JMP loads all the data and then updates the corresponding columns&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_3-1748413829253.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/76293i31AB00DF734AB2C3/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_3-1748413829253.png" alt="jthi_3-1748413829253.png" /></span></P> <P>Depending on how your data gets updated, you could also create a Workflow to handle the updates</P> Wed, 28 May 2025 06:33:08 GMT https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876725#M103977 jthi 2025-05-28T06:33:08Z https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876864#M103986 <P>please note that any processing steps (new columns, formatting, grouping)&nbsp; will be deleted during the "update".<BR />For "new columns", there is a warning - the other settings get deleted without a warning.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="hogi_0-1748454737513.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/76342iD68EB1BF95047BFE/image-size/medium?v=v2&amp;px=400" role="button" title="hogi_0-1748454737513.png" alt="hogi_0-1748454737513.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>there are several posts in the wish list to optimize the behavior.</P> <P><LI-MESSAGE title="Join, Concat and Update" uid="555726" url="https://community.jmp.com/t5/JMP-Wish-List/Join-Concat-and-Update/m-p/555726#U555726" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> <P><LI-MESSAGE title="universal &amp;quot;update&amp;quot; button for imported data" uid="467972" url="https://community.jmp.com/t5/JMP-Wish-List/universal-quot-update-quot-button-for-imported-data/m-p/467972#U467972" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-idea-thread lia-fa-icon lia-fa-idea lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> <P>Please support them if you need functionality beyond what is possible at the moment in JMP.</P> Wed, 28 May 2025 17:52:48 GMT https://community.jmp.com/t5/Discussions/Can-JMP-data-table-be-updated-with-new-input-from-same-excel/m-p/876864#M103986 hogi 2025-05-28T17:52:48Z