cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
qli107966
Level I

How to create Data Tables names so it can be concatenated regardless any specific file names

Hello,

 

I'm making a workflow but having one issue now, how should I modify below JSL so that JMP can concatenate all excel files from this folder regardless the actual file names?  

 

Can anyone please advise? Thanks!

 

--------------------------------------------------

Data Table( "S3_PM5" ) << Concatenate(
Data Table( "R3_PM2" ),
Data Table( "Q1_PM5" ),
Data Table( "KTC_Beta_BL_PM4" ),
Output Table( "Untitled 19.jmp" ),
Create source column
)

3 REPLIES 3
jthi
Super User

Re: How to create Data Tables names so it can be concatenated regardless any specific file names

Have you tried using Multiple File Import?

-Jarmo
qli107966
Level I

Re: How to create Data Tables names so it can be concatenated regardless any specific file names

Yes but my question is at step#2 Concatenate tables.

 

What kind of JSL should I write here in order to have JMP concatenate all files into one? the total files number and each file name can be random.

 

 

qli107966_0-1727847419181.png

 

jthi
Super User

Re: How to create Data Tables names so it can be concatenated regardless any specific file names

So the files look different as Multiple File Import wasn't able to concatenate them?

-Jarmo