- Posts: 189
- Thank you received: 9
Excel Writer with dynamic Sheet Name
- daniel.fung@xerox.com
- Topic Author
- Offline
- Elite Member
-
Less
More
7 years 2 months ago - 7 years 2 months ago #15367
by daniel.fung@xerox.com
Excel Writer with dynamic Sheet Name was created by daniel.fung@xerox.com
HI I am using v5.9.2.3 and trying to create an excel file with dynamically named sheets using a variable i set before in a loop , called <SheetName>
instead of say 50 sheets of data, i get 1 sheet named <SheetName>. Does ETL excel writer support variables in the writer config as shown below
if not, can you provide/support this feature or tell me how to arrange this. I have the requirement to generate a report of about 100 sheets. Each sheet name is a number that means something.
instead of say 50 sheets of data, i get 1 sheet named <SheetName>. Does ETL excel writer support variables in the writer config as shown below
if not, can you provide/support this feature or tell me how to arrange this. I have the requirement to generate a report of about 100 sheets. Each sheet name is a number that means something.
Last edit: 7 years 2 months ago by daniel.fung@xerox.com.
Please Log in or Create an account to join the conversation.
7 years 2 months ago #15369
by admin
Mike
ETL Architect
Replied by admin on topic Excel Writer with dynamic Sheet Name
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- daniel.fung@xerox.com
- Topic Author
- Offline
- Elite Member
-
Less
More
- Posts: 189
- Thank you received: 9
7 years 2 months ago #15370
by daniel.fung@xerox.com
Replied by daniel.fung@xerox.com on topic Excel Writer with dynamic Sheet Name
Thanks , it works, i was close, seems that i needed the {GetVariable('<MySheetName>')} syntax for sheet name:
i am not sure what SourceChanged; in the calculation does however.
i am not sure what SourceChanged; in the calculation does however.
Please Log in or Create an account to join the conversation.