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

Name the columns after using cross tab

mznaas
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 $$$$
3 REPLIES 3
LordNeilLord
15 - Aurora

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

pankajk
10 - Fireball

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.

mznaas
5 - Atom

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

Labels