800359_en-US

liliconcom

Excel Import: Multiple Series Stack example

Does anyone have a good example of using the Multiple Series Stack option in the Excel Import Wizard? All the examples I contrive need manipulation in JMP after the data are imported. I'm looking for a one-step example.

Re: Excel Import: Multiple Series Stack example

I am not sure whether I understand your question, but I took a video clip which is to import sample import data Texas Precipitation.xlsx and do some settings change in excel import wizard.

Re: Excel Import: Multiple Series Stack example

Thank you @Da_Li, this is helpful.

I was hoping it would work like it does in Tables > Stack - if you have both a precipitation and temperature series, it would bring in as a column for precipitation and a column for temperature. 

Re: Excel Import: Multiple Series Stack example

Here is a recent example I used with a customer where each "dataset" in the spreadsheet represents a different molecule to look at stability over time.  FYI, I added a "na" for one of the results to demonstrate looking at data type/ modeling type before starting analysis.  Ended up with 4 columns Dataset, Time point, Time point unit, and %HMW.  Also had to write a formula to put all time points into the same unit.