Output Data - Overwrite

[suby]

Hi All,

I'm taking an workbook with multiple sheets and doing some transformations and  i overwrite the data by taking the fullpath&SheetNames on my output data Configuration which is fine.

After my output I don't want the fullpath&SheetNames to be included in my output so that the number of columns matches exactly my input Data columns with output Data columns and how tis can be achieved ? any thoughts please

Thanks

[binuacs · Accepted solution]

@suby have you uncheck the keep field in output option? also use the select tool and unselect the fields you dont want in the output file

[IraWatt · Accepted solution]

Hey @suby,

Make sure here is unticked:

[suby]

Many thanks IraWatt that does the trick..

Thanks binuacs.

[suby]

Hi Irawatt,

In my Output configuration i unchecked the "Keep field in Output" but still i get the FullPathandSheetNames in my output Data set.

I don't want the  FullPathandSheetNames in my output file...just to let you i do  have a select tool before my output data configuration but if i uncheck the  FullPathandSheetNames on the select tool then i get an error.