Sort error after Crosstab

[maygross]

I'm creating a workflow that pulls our top customers for the current month and compares them through the past couple months. I'm using a crosstab to group by the customers and make the months the column headers. My issue here is that when I try to sort after the crosstab, the sort is not recognizing the new months columns. It only recognizes the customer name column. I previously used this workflow with an in-db tool and the sort worked then but it isn't working for me when I use a Teradata bulk loader. How do I fix this?

[binuacs]

@maygross One option remove the sort tool and add a new one and try again

[maygross]

Doesn't solve my problem unfortunately

[binuacs]

@maygross Are there any warnings in the result window? Also, can you create the same workflow in a new canvas and try again?

[maygross]

The only warning tells me that the field is missing. 

[binuacs]

@maygross are you able to see the field 202302  in the Cross Tab output ?

[maygross]

No, I'm not. Thats the issue here

[binuacs]

@maygross Check your data from the input tool and see why this field not populating in your cross tab tool