community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Regarding XML

Meteor

Hi Guys,

I`m working on a XML File where I need to get the file and plugin.Capture.PNG

 

Using the Parse Tool

  • Parse using File tag I get

FileName

File

A

A1

A

A2

A

A3

A

A4

  • Parse using Guisettings tag I get

FileName

Plugin

A

A1

A

A4

A

A2

A

A3

                                 

So I`m having trouble to join these two into one table, I had tried using Join Tool seems not working.

Comet

What would your desired output be from the example tables? 

Meteor

Hi @DanS,

 Let me Explain using the real data:-

 

First Parse:-

FileNamePosition1File
A1BS209AON.csv
A2BS209AIN.csv
A3BS209BBA.csv
A4Record_Count.txt
A5File_Okb.txt

Second  Parse:-

FileNamePosition2Plugins
A1DynamicInput
A2DynamicInput
A3DbFileOutput
A4DbFileOutput
A5DbFileInput

Desired Output:-

FileNamePosition1FilePosition2 
A1BS209AON.csv1DynamicInput
A2BS209AIN.csv3DbFileOutput
A3BS209BBA.csv4DbFileOutput
A4Record_Count.txt2DynamicInput
A5File_Okb.txt5DbFileInput

 

As you can see the order changes.

I hope I have explained correctly.

Labels