Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i have a crosstable lookinkg like this. i got a value connected to a location on each date. how can i connect the calendar week / week number (like the date 02.01.2021 would get the number 1, because its in the first week of the year) to each date? is there some way to "iterate" over the variable names, to do something like
calendar week = week([22.2.2021]), but for all imported dates?
my Crosstable import looking like this:
Directory;
CrossTable(date, *value*)
LOAD location,
[22.2.2021],
[23.2.2021],
[24.2.2021],
[25.2.2021],
[26.2.2021],
.......more dates
FROM
[***.xlsx]
(ooxml, embedded labels, table is Sheet0);
Try use LOAD * instead of specifying the column name. But this is assuming that the order of the columns is fixed.
thanks, thats helping my code look cleaner 😄
Any idea on how to solve my problem?
If you want to get the week number, then use the week function on the date to get the week.
week([Date])
You probably need to do it using resident load after the crosstable.