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! 

[afv2688]

Hello @Skyrone ,

Check out this example I created a while ago.

It uses a txt to read flat files and changes the length, data type and column names based on the input of a second file.

This is done by updating the xml directly

Check it and let me know your thoughts

Regards

[Skyrone]

Hi there,

Thank your for you quick answer. Unfortunately, I don't have the same Alteryx version as you (2019.3), and cannot update it right now. 

Can you send elements separately maybe ? 

Thank you again :- )

[afv2688]

Here you go,

Regards

[Skyrone]

Hi back,

Thanks for the share. I've been trying to use it for the last hour but can't manage to apply it to my files.

The big difference it that I have a csv input file instead of a txt.

I believe the main difference is in the macro FFI.yxmc, but I can't find what to change.

Do you have any ideas ? 

Thanks in advance.

[afv2688]

Hello @Skyrone ,

Could you share dummy files with the examples? Just to be sure about how data comes in.

Regards

[Skyrone]

Hi,

Sorry about the late answer.

Here's the two file that I use in my case.

Thank you !

[afv2688]

Hello @Skyrone 

How about this then?

Regards

[Skyrone]

Hi,

Again, could you kindly send elements separated ? I cannot import the .yxzp with my 2019.3 version of Alteryx.

Thank you so much !!

[afv2688 · Accepted solution]

Here you go

Regards