Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Name the columns after using cross tab

Highlighted
5 - Atom

I am using cross tab to create 2 new columns, I want to later use these 2 columns to compare value between the two. I can not use select or formula tool to compare after crosstab. Do I output data and then input it for analysis or is there an easier way?

 

 

Existing AExisting BExisting C CrossTab_NewACrossTab_NewB
RPIDCategoryAPN $$$$
RPIDCategoryAPN $$$$
Highlighted
Alteryx Certified Partner

Hey @mznaas 

 

It might be easier to help if you can share an example workflow as you can name the columns before the crosstab which might help

Highlighted
9 - Comet

agree with @LordNeilLord that you need to provide more info. But if you have to compare the 2 fields you have to have some more 'tools' before the comparison...... you can use Dynamic Select to select only the 'fields' required for comparison?

Startswith( [Name], "CrossTab")

Toolmastery on Dynamic Select:  https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Select/ta-p/89...

But if you provide more info, someone can help.

Highlighted
5 - Atom

I used a union tool after crosstab, which allowed me to add formula tool, and it worked

Labels