Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Getting error trying to create a custom column in the transformation

I have a report the data is structured (in Excel) as per example: BuildingSite EstimatedRepairDate ActualRepairDate EstimatedNumberofOffices Northeast 8/1/2022 8/12/2022 5 Southeast ...
  • davehus's avatar
    3 years ago

    Hi Anonymous ,

     

    Try using the conditional column as below.

     

     

    Hope this helps.

    Did I help you today? Please accept my solution and hit the Kudos button.