Icon

Week 23 - SuperBytes Salaries

Recently, SuperBytes realised they have underpaid one of their managers, Max Date, by around £5,000 over the course of his career. They want to know if they’ve done the same for any other managers. Assume all managers have received paychecks (correct or incorrect) up to the present date (5th June 2024)

URL: preppindata.blogspot.com/2024/06/2024-week-23-superbytes-salaries.html https://preppindata.blogspot.com/2024/06/2024-week-23-superbytes-salaries.html

TeneuresSalariesAmount paidjoined FormattingName Formatting NameFormatting Namejoining based on NameCurrent dateChange current date in end column to dateconvert string end date to datestart date-enddateExpected Total salarydifference b/w paid vs expected salaryfilter difference between salariesselecting need columnsExcel Reader Excel Reader Excel Reader Joiner String Manipulation String Manipulation String Manipulation Joiner Create Date&TimeRange Rule Engine String to Date&Time Date&TimeDifference Math Formula Math Formula Rule-basedRow Filter Column Filter TeneuresSalariesAmount paidjoined FormattingName Formatting NameFormatting Namejoining based on NameCurrent dateChange current date in end column to dateconvert string end date to datestart date-enddateExpected Total salarydifference b/w paid vs expected salaryfilter difference between salariesselecting need columnsExcel Reader Excel Reader Excel Reader Joiner String Manipulation String Manipulation String Manipulation Joiner Create Date&TimeRange Rule Engine String to Date&Time Date&TimeDifference Math Formula Math Formula Rule-basedRow Filter Column Filter

Nodes

Extensions

Links