Integer numeric colums, fuse to date

[Loeckli]

I have the following column, which have the datatype $numerci $integer. One column stands for the calendar week and the other for the year.The Date should always be the first day in this calender week. 

Week	Year	Date
6	2022	07.02.2022
7	2022	14.02.2022

How would one solve this in the data load editor ?

[Or · Accepted solution]

What exactly is the issue you're trying to solve?

If you're trying to create the Date column from the Week and Year columns, try:

MakeWeekDate(Year, Week) as Date

[Loeckli]

Thanks that was exactly the solution I was looking for!!