Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transfer the solution from Excel to Alteryx

awojciechowski
8 - Asteroid

Hello,

I need yours help because I just started my way with Alteryx.

 

What I need is not easy to say but in attachment you can find text file with code to Excel macro (unfortunately I can't attached here *.xlsm file) - I need transfer this solution to alteryx.

In Alteryx I want import (input) Excel file (*.xlsx or *.csv) and after i run workflow I want export file in *.XML format (which looks the same as this one after i use Excel macro).

 

I found one solution in Community but it works not in the same way, please try use it and mine solution in Excel and compare both files in final version.

https://gallery.alteryx.com/#!app/XML-Output/565bfd4caa690a12542665e3

 

I will be very grateful for your help :)

 

Artur

 

3 REPLIES 3
Inactive User
Not applicable

You can export the file as CSV and the delimiter can be \0. That way your XML is not modified and then you can just change the extension afterwards.

awojciechowski
8 - Asteroid

Hello Ryan,

Thanks for answer, could you prepare it and share me this solutions in Alteryx, then i will check how this works.
I have very basic knowledge in Alteryx so I'm not sure how prepare what you said.

 

Thanking you in advance,

Artur

awojciechowski
8 - Asteroid

https://gallery.alteryx.com/#!app/XML-Output/565bfd4caa690a12542665e3 

This solutions is enough.

I change little this code and it works good.

 

Labels