Cross tab making columns unknown

[Joker_Hazard]

Hey guys.

My cross tab is bugging. For some reason it is making all my columns unknown. 

I have another crosstab that works perfectly:

Few keypoints:

- Both crosstab have data flowing through them
- There is no difference between them.
- I have already tried deleting and inputing another one.

Can someone help me pls?

[FilipR]

Both Cross Tab and Transpose tool will lose metadata (column names) when you edit something in the workflow leading to them. Re-run your workflow. You should see the column names again (unless there's an error before the data reaches the Cross Tab). Also, make sure there actually is any data flowing into the Cross Tab that is giving you issues.

[Joker_Hazard]

@FilipR 

Interesting. However, I deleted crosstab tools and inputted new ones.

It worked for the first time, the second run it broke again. 

[nlundgren]

Hi @Joker_Hazard - have any of your input files changed? If a field name has changed it might be showing you that error... i.e. if your input file was called "Data" and is now "Data (1)", etc., then it might not have the fields you had previously specified within that cross tab tool. 

If not - it looks like you have interface tools baked into your workflow. I wonder if something in the backend of those tools on the cross tab could be causing it? 

[FilipR]

@Joker_Hazard is there a macro in your workflow? If there is, please check if this is selected in the Interface Designer (inside the macro):

Also, did you confirm there is data actually flowing into the Cross Tab tools that are giving you the error? I suspect the issue occurs before it reaches the tool.

[Joker_Hazard]

@nlundgren Hey!

My data is coming directly from a dynamic input, from SQL table. It is also an APP, with calendar tool and multiple action tools.

Very interesting that IF I remove app tools, and input the dates manually on the scripts, the cross tab works and don't get lost.

I am very confused..

[Joker_Hazard]

It is an application, with date and action tools. I will flag this anyway to check if it works!