COPY THE FILE FROM TEMPLATE USING SHAREPOINT CONNECTORS AND ACCESS THE NEW FILE USING EXCEL CONNECTORS. IF YOU ARE UNSURE ABOUT FIELDS, MAP THEM ON TEMPLATE FILE, COPY THE MAPPING FROM CODE VIEW AND THEN PASS TO DYNAMIC FILE NAME 'ROW' ATTRIBUTE.
BE SURE TO MANUALLY TYPE TABLE1 OR WHATEVER TABLE NAME IS GOING TO GET COPIED.
THE MAPPING IS TO BE DONE LIKE THIS