803114_en-US

liliconcom

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
)

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

Have you tried using Multiple File Import?

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.

 

 

 

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?