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 - even with slight differences

Status: New Submitted by on ‎02-17-2022 04:37 AM
2 Comments (2 New)

Hi,

I want to use the Import multiple files ..." to load csv files with slightly different structures: therer is huge overlap of columns, but some files have columns which the others don't.

In this case, the import seems to stop if a deviation is detected in a file.

 

my Wish: the program loads all files and there is a control to choose:

- just load columns that are available in all files

- load all data (and accept that there is no data for part of the files)

 

Thanks,

 

Holger

2 Comments
hogi
Level XI
‎03-22-2022 04:27 PM
‎03-22-2022 04:27 PM

Ah, I just found out that this is already requested 2 years ago:
https://community.jmp.com/t5/JMP-Wish-List/Multiple-File-Import-Force-Combine/idi-p/255929

 

For sure, there is a workaround:

Let jmp generate several tables - one table for each variant of input files that it detects

- then concatenate the tables.

 

But it would be much easier to have just the 3rd option:
- I don't care about missing entries, just generate ONE file

 

besides

- stack similar files

- one table for each file

hogi
Level XI
‎12-16-2022 06:23 AM
‎12-16-2022 06:23 AM

Status could be changed to duplicate