Headers are not being retained after crosstab

JarodVZW

All,

I am trying to turn a date column into headers and use an actuals column as values. The problem is the column headers are not being retained so i am unable to use the column headers in the data cleansing tool or any tools after the crosstab. I can see the columns in meta data so they are there but i am unable to use them. I ran the workflow and they showed up however they disappear eventually.

Thanks in advance!

danrh

The issue here is probably that the workflow doesn't "know" what the new columns will be before you run it.  To counteract this, I'd suggest using a Multi-Field Formula tool instead of a Data Cleansing.  This allows you to select "Dynamic or Unknown Fields" from the list and run some data cleansing manually, using a formula like:

Trim([_CurrentField_])

The goal is to stick to tools that allows you to select unknown fields.  If this isn't possible, see how much you can do to prep the data prior to using Cross Tab --- maybe run the Data Cleansing on the original value column instead of all the resulting columns?

If you need more specific advise, posting some sample data would be invaluable.  Hope it helps!