All,
My workflow goes like this first transpose then summarize and Join on common fields.
I'm reading in the sheet 1 TO Sheet 5 using a batch Macro then I'm transposing
When the Macro Runs
when sheet 1 is read and transpose using Record ID as Key column and Data Columns as ID and FOLDER
when sheet 2 is read again it works ok when transpose using Record ID as Key column and Data Columns as ID and FOLDER
when sheet 3 is read again it works ok when transpose using Record ID as Key column and Data Columns as ID and FOLDER
but
when sheet 4 is read again I'm not getting any errors on my Transpose tool but i get an error on the Summarize tool
because the summarize tool is configured using ID and FOLDER which are common for sheet 1 to sheet 3 which runs ok but not for sheet 4 or sheet 5.
I'm looking for a dynamic solution where
sheet 4 column header M_ID Should be dynamically renamed to ID and FILE ID should be renamed to FOLDER.
sheet 5 column header F_ID Should be dynamically renamed to ID and FILE ID should be renamed to FOLDER.
So that all my transpose , summarize and Join will continue to run through.
Thanks
