-
Unpivot and Pivot
Happy Friday! I'm not sure how to start. The data in the yellow section is what I currently have in the magic ETL. I want the result to look like the data in the green section. I've tried to Unpivot the data and Pivot them but have been unsuccessful. Could someone shed some light on this issue? Thank you very much!
-
How to use Rank function to fill in the data
There are two tables, the Existing Pay/Bill Table and the EditHistoryPlacement Table, that I wish to join together using the PlacementID column in order to generate the data in the EXPECT Existing Pay/Bill Table. I'm considering the use of the RANK function (with dateAdded… as a parameter) and the PARTITION clause (with…
-
Case statement not working
Please help with my ETL formular. I'm not sure why my case only works for… WHEN AdditionalRecruiter = '' and RecruiterInOrder = 1 THEN 'Unassigned Owner' WHEN STR_CONTAINS(AdditionalRecruiter,',') THEN AllRecruiter WHEN AllRecruiter IS NULL THEN 'N/C' Below is the code I'm using to populate the 'RecruiterOutcome' column.…
