Dynamic Variables - Rename Files

More
1 year 8 months ago #24505 by prashant
HI Team,

I had like to rename a file , loop files read through variables in #Ename#

C:\Users\Superadmin\Documents\KBIAutomation\eomaterial\input\#EName#_eomaterial_template.xlsx



Is this supposed to be 
1. Static ? Didn't work 
2. Calculation? what should change?
3. Variable?


 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24508 by admin
Sorry I am really confused about your question, can you clarify it please.

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24509 by prashant
if #EName# is a variable , 

it's working fine with earlier FILE Operation package to rename file C:\Users\Superadmin\Documents\KBIAutomation\eomaterial\input\#EName#_eomaterial_template.xlsx

BUT 

not with dynamic rename

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago - 1 year 8 months ago #24510 by admin
This one works


Mike
ETL Architect
Last edit: 1 year 8 months ago by admin.

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24511 by admin
Plus if you want to rename multiple files you can use 

#CurrentSourceFile# variable and #CurrentSourceFileNumber#

Variables





They also work inside calculation 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 8 months ago #24517 by prashant
Thank you,
Still struggling with the myriad of options available !

1. #ROOT# is currently not listed in the variable list , it defines root of what?
2. #Currentfilesource# is defined by ?




 

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save