Discussions
-
How can I replace the empty values from one column with the unique value from a different column?
I have Estimated Budget hours (ie 800) and then sometimes we Update our hours (ie 3,600) to a new "Updated Budget" if needed. (This "update budget" is set up to include the original estimate so I cannot simply add them) I need a column to combine using the Updated Budget hours except when ' ' empty or 0, then use the hours…
-
Date Difference contingent on other column values SQL
Hi I am trying to find the date difference between different rows with like IDs. Please see screenshot of Excel to see data needs clearly. Also screen shots attached from SQL transforms. SQL Does Validate: Transform 1 SELECT sp_palapprovals_workflow_history_dwb1. *, Case when (`Primary Item ID`=`Primary Item ID`) and…
