Importing global table to schedule source without referring rows and columns

Importing global table to schedule source without referring rows and columns

anggoro_p
Not applicable
15 Views
1 Reply
Message 1 of 2

Importing global table to schedule source without referring rows and columns

anggoro_p
Not applicable

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?

0 Likes
Accepted solutions (1)
16 Views
1 Reply
Reply (1)
Message 2 of 2

jeff_nordgren
Not applicable
Accepted solution

@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.

0 Likes