Copy paste data/import Data into another template

[ShantanuDagar]

Hey all.

So I have a data set extracted from some source at regular intervals and has 26 columns. And multiple 1000 rows.

I need to import this data or copy/paste this data into another excel file that is empty but has column headings written which are different from the previous file. The alignment of the data remains the same. And this should become the input of the future workflow.

Any idea how to do this?

Was a simple copy/paste in excel. (Select all data in file 1 and copy it. Select cell A2 in second sheet and then paste it there) As the alignment is the same.

[Qiu]

@ShantanuDagar 
I think we can use the option "Preserve Formatting on Overwrite" in the output tool.

Just a quick sample below.

[grazitti_sapna]

@ShantanuDagar , please use the below configuration in your output data tool. Please note that the start range must be from A2 as 1st row will contain header in output file and the end should be the last column and the maximum number of records which you think might come. In case the number of records will be dynamic and you are not sure about the number of records then you can use formula tool to dynamically set the end range. Added both flows in single workflow.

1. The configuration for specified range:

2. Config for dynamic changing range:

[ShantanuDagar]

@grazitti_sapna @Qiu There is a 10000 cell limit for the import of data in the tool. I surely have multiple 10000s cells.

[gyang3]

@ShantanuDagar instead of a text input tool and pasting the 10000s of cells into it, you can pull in an Input Tool instead of the text input and just point it to the location of the folder that contains the data you need to import. Not sure if its needed but I use a wildcard like the *.xlsx shown in the screenshot below. This basically tells the tool to pull in any xlsx files contained within this specific folder. 

Would that work or is there some other limitations within your use case? If that helps accomplish what you're looking to do, please mark as a solution. 

[grazitti_sapna]

@ShantanuDagar , We have just provided you with the sample using Text input tool but in your case you can use input data tool and connect to the file as mentioned by @gyang3  and then apply next steps as mentioned in my workflow. Or you can copy paste data in text input tool.