Columns not pulling in the data from the source file.

[CRogers22]

Hello All,

I'm working on a workflow and I have columns where all the data for those columns has disappeared. The headers are pulling in but nothing else. I have no idea why, I've changed nothing about my approach. 

Has anyone experienced this and what did you do to fix it?

Any help is greatly appreciated.

[CoG · Accepted solution]

More information would be helpful:

What data source are you working with?

Is this issue occurring via an Input Tool (or connector) or is it occurring in the middle of the workflow (i.e. from which Tool are you observing this issue)?

This and any other details you can add would be very helpful. 

[CRogers22]

@CoG 

I'm using an excel file for my input.

Using an existing excel file.

It seems to be at the formula tool. 

The formula is:

datetimeformat(

datetimeparse([Case Create Date],"%m-%d-%y"),

"%b")

Not sure why that would remove Data.

[CRogers22]

@CoG 

This was an error on my part after working through your questions I noticed one of my filters were removing what I was looking for.

Thank you for your time.