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%3Emultiple%20file%20import%20-%20even%20with%20slight%20differences%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-461713%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20want%20to%20use%20the%20Import%20multiple%20files%20...%22%20to%20load%20csv%20files%20with%20slightly%20different%20structures%3A%20therer%20is%20huge%20overlap%20of%20columns%2C%20but%20some%20files%20have%20columns%20which%20the%20others%20don't.%3C%2FP%3E%3CP%3EIn%20this%20case%2C%20the%20import%20seems%20to%20stop%20if%20a%20deviation%20is%20detected%20in%20a%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20Wish%3A%20the%20program%20loads%20all%20files%20and%20there%20is%20a%20control%20to%20choose%3A%3C%2FP%3E%3CP%3E-%20just%20load%20columns%20that%20are%20available%20in%20all%20files%3C%2FP%3E%3CP%3E-%20load%20all%20data%20(and%20accept%20that%20there%20is%20no%20data%20for%20part%20of%20the%20files)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHolger%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%3EUser%20Interface%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%20multiple%20file%20import%20-%20even%20with%20slight%20differences%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-472105%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EAh%2C%20I%20just%20found%20out%20that%20this%20is%20already%20requested%202%20years%20ago%3A%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%3Ehttps%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%3EFor%20sure%2C%20there%20is%20a%20workaround%3A%3C%2FP%3E%3CP%3ELet%20jmp%20generate%20several%20tables%20-%20one%20table%20for%20each%20variant%20of%20input%20files%20that%20it%20detects%3C%2FP%3E%3CP%3E-%20then%20concatenate%20the%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it%20would%20be%20much%20easier%20to%20have%20just%20the%203rd%20option%3A%3CBR%20%2F%3E-%20I%20don't%20care%20about%20missing%20entries%2C%20just%20generate%20ONE%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebesides%3C%2FP%3E%3CP%3E-%20stack%20similar%20files%3C%2FP%3E%3CP%3E-%20one%20table%20for%20each%20file%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%20multiple%20file%20import%20-%20even%20with%20slight%20differences%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%40Sarah-Sylvestre%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%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%20multiple%20file%20import%20-%20even%20with%20slight%20differences%20-%20Status%20changed%20to%3A%20Duplicate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-798418%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EDuplicate%20of%3A%26nbsp%3B%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