Hi,
I have day wise attendance register ( Sheet Name-INPUT) of Jun-24 for salary calculation.
In each month , actual cut-off may varies for salaries & for remaining days attendance is forecasted. This forecast attendance gets regularized in next month.
e.g. in May’24 attendance from 21-May-24 to 31-May-24 was forecast which is regularized in Jun’24 month . Also in Jun’24, attendance from 19th Jun to 30 Jun 24 is forecast. This can be identified by “A” & “F”.
The required output is Sheet-Output. I have achieved this using transpose, I wanted to avoid transpose step. As there are many sheets & rows in each month.
Therefore, I was trying dynamically promote header using list function.
I was following this video(https://youtu.be/QBhG8m-zio0?si=SzI0Kfy0Q0ua-l5w) . But I am facing error during use of step [ List.Transform( Custom1,each Text.Combine(_,“|”))] . The error is as below. Because in my data set is 3rd row is date type.
"
Expression.Error: We cannot convert the value #datetime(2024, 5, 21, 0, 0, 0) to type Text.
Details:
Value=21/5/2024 12:00:00 AM
Type=[Type]
"
I need to help to combine these different data types.
Dynamically Promote Header.xlsx (36.9 KB)
Thanks in advance