Forum Discussion
Date field change to text - when merge two tables using python code fro transform purpose ?
Hi All,
Need suggestion in data manipilation using python. I need to identify the Employee is qualified for training or not in DSR_DNQ table depending on certain condition from Qualification table.
So I merge two tables with python to transform and shape the data but the datefields are all text.
How to change the format ?
2 Replies
ashmitp869 , I do not see any dates in the Start and end dates. Seem like format issue. If that not working bring them as text and format them in Power Query
Hi ,I can't do this in power query as my ultimate goal is to merge two dataset and put this condition which depends on two table.
- Qualified =
CASE WHEN Timesheet Date >=Date Start && Timesheet Date <= Date End Comments contains “L” then “Learner”
WHEN Timesheet Date >= Date Start && Timesheet Date <= Date Expiry then "Qualified" WHEN Timesheet Date >=Date End && Date Expiry = null then "Not Qualified" WHEN Timesheet Date < Date Start then "Learner"I had raise this before but didn't got any reply.
- Qualified =
