I am looking for some help in renaming the filed names.
I have a scenario where my filed names are like Customer Name, Customer City, Customer Location etc;. I have to change them to Member Name, Member Location, Member City,etc., i.e the fields like Customer * should be changed to Member *. I used mapping load and the function 'rename fields', but again since this approach needs to maintain a list of old and new filed names, I am trying avoid this instead trying for a solution using wildcard match like field names starting with 'Customer *' should be changed to 'Member *'.
You can build a loop with nooftables(), Tablename(), nooffields(), fieldname() to generate the mapping table during the loop after your normal script where you can search in the fieldname vor your wildcards. In the gui you can build the fieldnames with variables.
Thank you for the reply. I am trying to achieve the above task in my UI. What I am doing here is I am calling all my QVDs in a loop, once the tables are created in UI ,then I am trying to rename the fields.
Can you please try to post a sample script with the above suggestions you made.