I have a task that need extract several excel workbook , then rename and combined based on a key; The result also write to an Excel workbook which I have a template; My question is how to order the results based on Template columns Names. I can manually re-order them, but I am handling excel sheet with 100 and 300 columns source tables, if I manually re-order, that needs every time to re-order again; See attached image: Template has " ILI Reference Girth Weld"; FME has "NDE Report Issue#" after "Dig Phase #"; I also can read the Template and get the order, but I don't know how to merge to the workflow, also feel redundancy since Writer already reference the Template. Any solution to this issue? Thank you.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.