464452_en-US

liliconcom

Importing Excel into JMP - Concat Excel Not Transferring Over

Hi there - I'm using the Import function on JMP to import an excel into JMP (because I will be updating the excel file and want the JMP file to update).

I have a few =concat() functions in the excel file, and whenever I import into JMP via wizard, in JMP it shows up as #NAME? for every cell that has the concat function, rather than displaying the actual value as it does in excel.

What is the workaround so that I can make it show the actual value? Thank you!!!

Data TableRe: Importing Excel into JMP - Concat Excel Not Transferring Over

What I have found, is that if one opens the .xlsx version of the Excel, directly into JMP, the cells with =concat() values in them are read in as a missing value.

If one uses the Excel JMP addin, the =concat() cells are transferred into JMP correctly.

If one copy/paste from Excel to JMP, the data are input correctly.

If the Excel spreadsheet is saved to a .csv format, and then the .csv is opened directly into JMP, the =concat() cells are correctly 

 

I suggest that you use one of the alternative approaches that properly read in the =concat() cells as your workaround.

Re: Importing Excel into JMP - Concat Excel Not Transferring Over

Perhaps you also may look at the full process, seems that the cells with "concat" are redundant information. Concat can also be done in JMP, so you could import only neccessary data. Processes spread over different tools tend to be fragile, import from Excel is specifically fragile, as it depends on so much parameters. And anyone may change one of these at some time in an Excel-File.