Hello All , I need help in importing some of the data from one file to another file which will have set header column. Input file - This Input file will have improper header naming convention. eeproduct nameproductzz locationemplueenamewwwytrConractghNumberaCaliforniarty12345bARIZONAfgh45678cSan Josejkl987dSan Franciscoyui2366E New Yorkqwe2316fNew Jerseyasd453gGeorgiazxc5678 Output file Template - In this template data from Input file should be imported as per correct header wise. Contact Number Product LocationEmployee Name Please advise Thanks in advance! Regards, Rajeev

how to import data from one file to blank output file under defined column header

Hello All ,

I need help in importing some of the data from one file to another file which will have set header column.

Input file - This Input file will have improper header naming convention.

eeproduct name	productzz location	emplueenamewww	ytrConractghNumber
a	California	rty	12345
b	ARIZONA	fgh	45678
c	San Jose	jkl	987
d	San Francisco	yui	2366
E	New York	qwe	2316
f	New Jersey	asd	453
g	Georgia	zxc	5678

Output file Template - In this template data from Input file should be imported as per correct header wise.

Contact Number	Product Location	Employee Name

Please advise

Thanks in advance!

Regards,

Rajeev

Developer

Common Use Cases

Preparation

Iterative Macro

Accepted answers

Rajeev18

Hi @Htaneja2

Sorry am not able to find any solution canvas attached. Could you please share it again.

Thanks,

All comments

JosephSerpis

Hi @Rajeev18 if you wanting to paste data into a template then you can either you the Command tool to copy the template to the output network location. You will need the output tool within designer to point to the output network location where the template is being copied to.

Another way is to use blob tools to copy the template as well which I've written a blog about.

Rajeev18

JosephSerpis

Thank you for the prompt reply. However while using the said method it did not work. Could you please revisit my example and advise.

Please note that in input file there are many column which is not suppose to get imported and in output file too there are many column which is not suppose to be imported with the input file.

Also the column header in Input file and Output file are not in same sequence .

Regards,
Rajeev

Htaneja2

Hi Rajeev,

please find the solution,

you can use a select tool and get the task done,

select the columns required and Also you can rename them, reposition them as per the sequence you want by the arrow keys (pic attached)

if you find the solution to be the correct and accurate one please mark it as "solution"

Solution for discussion.yxmd

re-order.PNG

Rajeev18

Hello @Htaneja2

Thank you for taking time and reviewing my queries. Just to clarify my queries I need data in output file where few data will be there from input file and some will be blank column. However with select tool i can get column which i want and i can arrange as well but blank column will not be incorporated in the output file and nor the sequence.

Please revisit my example and help.

Regards,

Rajeev

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703