question

Anggoro P avatar image
0 Likes"
Anggoro P asked Jeff Nordgren answered

Importing global table to schedule source without referring rows and columns

Hi,

I am curious if it is possible to import the whole global table into schedule source table without referring a specific row and column. The problem is that the number of rows in global table is uncertain, so it's impossible to link them one by one.

I got the idea to export the global table first to excel and then import the exported data into schedule source. However, it seems not efficient.

Any idea?

Choose One
global tableschedule sourceimport
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Jeff Nordgren avatar image
0 Likes"
Jeff Nordgren answered

@Anggoro P,

You can use the Excel Interface option to import an Excel file to a schedule, as you know. If you leave the "Total Rows" and "Total Columns" as zero, it will import a variable amount of rows or columns. I would use the "Add Table to MTEI" in the Process Flow Source to setup the basics for the Excel import, like where it will import the Excel info. Then just "clean up" whatever fields that need updating.

Thanks.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.