Apply header from one file to another data file

[Skyrone]

Hi everyone,

I've been looking in the discussions about that particular need but couldn't find the answer to my question.

Here's my struggle. I've got two files :

- File1 : my data

- File2 : the header description of my data

I'd like to find a method to automatically apply headers from File2 to File1.

Here's an example of File1 :

Field_String	Field_Date	Field_Int
Helloworld	36526	123
Toto	44198	456

And of File2 (I have it in delimited file, every columns has a length of 30 characters but I adapt it this way) :

Fieldname	Length	Datatype	Others infos…
Field_String	000020	CHAR
Field_Date	000008	DATE
Field_Int	000005	INT

Obviously, the metadata obtained with Basic Data Profile on File1 should look like what I have in File2, but that's not entirely the case (especially for date columns).

Do you know a way to do it?

Thank you for your help! 

[Skyrone]

It works, hopefully it will on my data.

Thank you again !! That's wonderful news for me...