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

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

qli107966 — Wed, 02 Oct 2024 01:36:02 GMT

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
)

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

jthi — Wed, 02 Oct 2024 04:30:04 GMT

Have you tried using Multiple File Import?

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

qli107966 — Wed, 02 Oct 2024 05:38:32 GMT

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

jthi — Wed, 02 Oct 2024 06:46:01 GMT

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