cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-461713%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E8%A4%87%E6%95%B0%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%20-%20%E5%A4%9A%E5%B0%91%E3%81%AE%E9%81%95%E3%81%84%E3%81%AF%E3%81%82%E3%82%8B%E3%82%82%E3%81%AE%E3%81%AE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-461713%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%82%84%E3%81%82%E3%80%81%3C%2FP%3E%3CP%3E%5B%E8%A4%87%E6%95%B0%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88...%5D%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%80%81%E3%82%8F%E3%81%9A%E3%81%8B%E3%81%AB%E7%95%B0%E3%81%AA%E3%82%8B%E6%A7%8B%E9%80%A0%E3%81%AE%20csv%20%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E3%83%AD%E3%83%BC%E3%83%89%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%E5%88%97%E3%81%8C%E5%A4%A7%E3%81%8D%E3%81%8F%E9%87%8D%E8%A4%87%E3%81%97%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%81%8C%E3%80%81%E4%B8%80%E9%83%A8%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AB%E3%81%AF%E4%BB%96%E3%81%AE%E5%88%97%E3%81%AB%E3%81%AA%E3%81%84%E5%88%97%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E3%81%93%E3%81%AE%E5%A0%B4%E5%90%88%E3%80%81%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AB%E9%80%B8%E8%84%B1%E3%81%8C%E6%A4%9C%E5%87%BA%E3%81%95%E3%82%8C%E3%82%8B%E3%81%A8%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%E3%81%8C%E5%81%9C%E6%AD%A2%E3%81%99%E3%82%8B%E3%82%88%E3%81%86%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E7%A7%81%E3%81%AE%E9%A1%98%E3%81%84%3A%20%E3%83%97%E3%83%AD%E3%82%B0%E3%83%A9%E3%83%A0%E3%81%AF%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E3%83%AD%E3%83%BC%E3%83%89%E3%81%97%E3%80%81%E9%81%B8%E6%8A%9E%E3%81%99%E3%82%8B%E3%82%B3%E3%83%B3%E3%83%88%E3%83%AD%E3%83%BC%E3%83%AB%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%3A%3C%2FP%3E%3CP%3E-%20%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%A7%E4%BD%BF%E7%94%A8%E5%8F%AF%E8%83%BD%E3%81%AA%E5%88%97%E3%82%92%E3%83%AD%E3%83%BC%E3%83%89%E3%81%99%E3%82%8B%E3%81%A0%E3%81%91%E3%81%A7%E3%81%99%3C%2FP%3E%3CP%3E-%20%E3%81%99%E3%81%B9%E3%81%A6%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E3%83%AD%E3%83%BC%E3%83%89%E3%81%97%E3%81%BE%E3%81%99%20(%E3%81%9D%E3%81%97%E3%81%A6%E3%80%81%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E4%B8%80%E9%83%A8%E3%81%AB%E3%83%87%E3%83%BC%E3%82%BF%E3%81%8C%E3%81%AA%E3%81%84%E3%81%93%E3%81%A8%E3%82%92%E5%8F%97%E3%81%91%E5%85%A5%E3%82%8C%E3%81%BE%E3%81%99)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%80%81%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%83%9B%E3%83%AB%E3%82%AC%E3%83%BC%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-461713%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E3%83%A6%E3%83%BC%E3%82%B6%E3%83%BC%E3%82%A4%E3%83%B3%E3%82%BF%E3%83%BC%E3%83%95%E3%82%A7%E3%83%BC%E3%82%B9%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-472105%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E8%A4%87%E6%95%B0%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%20-%20%E5%A4%9A%E5%B0%91%E3%81%AE%E9%81%95%E3%81%84%E3%81%AF%E3%81%82%E3%82%8B%E3%82%82%E3%81%AE%E3%81%AE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472105%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%81%82%E3%81%82%E3%80%81%E3%81%93%E3%82%8C%E3%81%8C%202%20%E5%B9%B4%E5%89%8D%E3%81%AB%E3%81%99%E3%81%A7%E3%81%AB%E3%83%AA%E3%82%AF%E3%82%A8%E3%82%B9%E3%83%88%E3%81%95%E3%82%8C%E3%81%A6%E3%81%84%E3%82%8B%E3%81%93%E3%81%A8%E3%81%8C%E3%82%8F%E3%81%8B%E3%82%8A%E3%81%BE%E3%81%97%E3%81%9F%E3%80%82%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FMultiple-File-Import-Force-Combine%2Fidi-p%2F255929%22%20target%3D%22_blank%22%3E%20https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FMultiple-File-Import-Force-Combine%2Fidi-p%2F255929%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E7%A2%BA%E3%81%8B%E3%81%AB%E3%80%81%E5%9B%9E%E9%81%BF%E7%AD%96%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3Ejmp%20%E3%81%8C%E8%A4%87%E6%95%B0%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E7%94%9F%E6%88%90%E3%81%99%E3%82%8B%E3%82%88%E3%81%86%E3%81%AB%E3%81%97%E3%81%BE%E3%81%99%20-%20%E6%A4%9C%E5%87%BA%E3%81%97%E3%81%9F%E5%85%A5%E5%8A%9B%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E3%83%90%E3%83%AA%E3%82%A2%E3%83%B3%E3%83%88%E3%81%94%E3%81%A8%E3%81%AB%201%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%3C%2FP%3E%3CP%3E-%20%E6%AC%A1%E3%81%AB%E3%80%81%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E9%80%A3%E7%B5%90%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%81%9F%E3%81%A0%E3%81%97%E3%80%813%20%E7%95%AA%E7%9B%AE%E3%81%AE%E3%82%AA%E3%83%97%E3%82%B7%E3%83%A7%E3%83%B3%E3%81%A0%E3%81%91%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%99%E3%82%8B%E6%96%B9%E3%81%8C%E3%81%AF%E3%82%8B%E3%81%8B%E3%81%AB%E7%B0%A1%E5%8D%98%E3%81%A7%E3%81%99%E3%80%82%3CBR%20%2F%3E%20-%20%E3%82%A8%E3%83%B3%E3%83%88%E3%83%AA%E3%81%AE%E6%AC%A0%E8%90%BD%E3%81%AF%E6%B0%97%E3%81%AB%E3%81%9B%E3%81%9A%E3%80%811%20%E3%81%A4%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E7%94%9F%E6%88%90%E3%81%99%E3%82%8B%E3%81%A0%E3%81%91%E3%81%A7%E3%81%99%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E3%81%9D%E3%81%AE%E3%81%BB%E3%81%8B%3C%2FP%3E%3CP%3E-%20%E5%90%8C%E6%A7%98%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%82%92%E7%A9%8D%E3%81%BF%E9%87%8D%E3%81%AD%E3%82%8B%3C%2FP%3E%3CP%3E-%20%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%94%E3%81%A8%E3%81%AB%201%20%E3%81%A4%E3%81%AE%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798065%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%E8%A4%87%E6%95%B0%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%20-%20%E3%82%8F%E3%81%9A%E3%81%8B%E3%81%AA%E9%81%95%E3%81%84%E3%81%8C%E3%81%82%E3%81%A3%E3%81%A6%E3%82%82%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798065%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F42584%22%20target%3D%22_blank%22%3E%40%E3%82%B5%E3%83%A9%E3%83%BB%E3%82%B7%E3%83%AB%E3%83%99%E3%82%B9%E3%83%88%E3%83%AB%3C%2FA%3E%3CSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-798418%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%E8%A4%87%E6%95%B0%E3%81%AE%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%AE%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88%20-%20%E3%82%8F%E3%81%9A%E3%81%8B%E3%81%AA%E9%81%95%E3%81%84%E3%81%8C%E3%81%82%E3%82%8B%E5%A0%B4%E5%90%88%E3%81%A7%E3%82%82%20-%20%E3%82%B9%E3%83%86%E3%83%BC%E3%82%BF%E3%82%B9%E3%81%8C%E3%80%8C%E9%87%8D%E8%A4%87%E3%80%8D%E3%81%AB%E5%A4%89%E6%9B%B4%E3%81%95%E3%82%8C%E3%81%BE%E3%81%97%E3%81%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798418%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E9%87%8D%E8%A4%87%3A%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FMultiple-File-Import-Force-Combine%2Fidi-p%2F255929%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FMultiple-File-Import-Force-Combine%2Fidi-p%2F255929%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

multiple file import - even with slight differences

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

4 Comments
hogi
Level XII

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 XII

Status could be changed to duplicate

hogi
Level XII