Table or Query options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello great people:
How can I fixed the Table or Query renege (in the input tool) fixed for a workflow? So that every month from the Excel sheet the same tab and table can be picket up?
Appreciate your help.
Thanks
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If i understood well, your filename is changing but your sheetname is fixed, right? If this is the case, when you concatenate the filename with the sheetname and use the dynamic input to import it, the sheetname can be fixed. for this example, it is 'Sheet1'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Felipe_Ribeir0 The file name and the tab name is same. I want to fixed the table range.so that workflow pick up the same tab and same renege every time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The select a range option of the input tool allow you to select the range of cells to import:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I did that. Just wanted to make sure every time does this option help to pickup the right range?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you know the range by looking at the excel file, and it is fixed, this will always import the same range, even if the excel file is updated.
