This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 :
And of File2 (I have it in delimited file, every columns has a length of 30 characters but I adapt it this way) :
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!
Go to Solution.
Go to Solution.
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
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 :- )
Here you go,
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.
Could you share dummy files with the examples? Just to be sure about how data comes in.
Sorry about the late answer.
Here's the two file that I use in my case.
Thank you !
How about this then?
Again, could you kindly send elements separated ? I cannot import the .yxzp with my 2019.3 version of Alteryx.
Thank you so much !!
Here you go