cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar

Multiple File Import - Force Combine

Status: Acknowledged Submitted by on ‎04-03-2020 12:25 PM
5 Comments (5 New)

I would like to suggest the ability to force MFI to combine files together, even if it finds differences.

 

Use Case: I am combining data from two instrument platforms where the data is set up identically, but the differences are enough that MFI separates the data into two tables if I have both instrument platforms. I am aware of all pertinent differences, and just want to leverage MFI for high quality, quick combination. I would like a radio button to 'force into one file' along with "Stack Similar Files" and "One Table for Each File".

 

While JMP does an amazing job most of the time, sometimes I know better than JMP

5 Comments
jszarka
Level IV
‎04-10-2020 01:55 PM
‎04-10-2020 01:55 PM

To quickly add on to that, it's common for me to have a .CSV or .XLS file that is identical except 1 out of N files has something silly like an extra empty column on the far right. Even if it was just an option to 'force concatenate' in the dialog box, that could be useful.

hogi
Level XI
‎03-22-2022 04:34 PM
‎03-22-2022 04:34 PM

Is there a possibility to define the columns explicitly - like it's possible for (single file) csv import
... and thereby hide the differences under the carpet?

nathan-clark
Level VI
‎03-22-2022 04:39 PM
‎03-22-2022 04:39 PM

I think those are great options. I've written my own addin which can do the force concatenation and it uses MFI as the backbone. Only a couple more features and I can deprecate my addin and just use JMPs functionality

Sarah-Sylvestre
Staff
Staff
‎12-14-2022 10:36 AM
‎12-14-2022 10:36 AM
Status changed to: Acknowledged

Hi @nathan-clark, thank you for your suggestion! We have captured your request and will take it under consideration.

hogi
Level XI
‎05-16-2023 12:56 AM
‎05-16-2023 12:56 AM

Another application case for:
force MFI to combine files together, even if it finds differences.

 

To get files fast into Jmp - and preprocess them afterwards:

https://community.jmp.com/t5/Discussions/Open-multiple-Files/m-p/632068/highlight/true#M83045 

(disable the header detection + force combine)