Cross tab making columns unknown

Question

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?

Joker_Hazard · Answer

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

Joker_Hazard · Answer

@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..

FilipR · Answer

@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.