Copy paste data/import Data into another template

Question

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.

grazitti_sapna · Answer

@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.

gyang3 · Answer

@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.

ShantanuDagar · Answer

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