Name the columns after using cross tab

[mznaas]

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	$$	$$

[LordNeilLord]

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 · Accepted solution]

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]

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