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 A | Existing B | Existing C | CrossTab_NewA | CrossTab_NewB |
RPID | Category | APN | $$ | $$ |
RPID | Category | APN | $$ | $$ |
Solved! Go to Solution.
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
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.
I used a union tool after crosstab, which allowed me to add formula tool, and it worked