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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Column Dynamic Combine

Asteroid

Hi Guys

 

I am reading table data from an XML which is from pdfs. These column names can be slightly different or exactly the same name.

 

The batch macro i have created kicks out the columns of the tables.

 

As such i am looking at a way to dynamically combine different columns together. The columns will only have the data or null values in

 

Cheers

Alteryx Certified Partner

Hi @Rohitpm,

 

Can you provide an example? I can't picture in my head what you need to happend

Asteroid

So here is an example of what i mean

 

Cost1Cost2Total1Total2Per1Per2Per3Per4
1       
 2      
  3     
   4   9
    5   
     6  
      7 

 

So i am trying to combine the fields that have a similar name so it is like this:

 

CostTotalPer
1  
2  
 3 
 49
  5
  6
  7

 

Hope that makes sense

Alteryx Certified Partner

@Rohitpm

 

I think you first need to transpose your data so it's long rather than wide, then look at how to identify the same names (in your example it was easy because you just need to remove the number but I suspect your actual data will be much harder). After that you can crosstab the data back into it's original format.

 

I'm not expecting your final workflow to be a simple as this but this should get you started.

 

If you want to post some examples of the actual headers that you are getting I can help you further

 

xml.PNG

Asteroid

Cool thanks alot :)

Labels