Forum Discussion
Solved
Oldest date from column as Column header
Hi, On a daily base I have e reporting file with the number of planned installs for the next 30 days. That 30 day window changes every day (+1 day). I would like to import that data from every...
I filtered by date so could use contains "/" to make the date table. Then I copied the query and filtered by does not contain "/" to get the values, then I merged by date AND column number (attribute) to get the final table.
Hi ToffeeMarkWork ,
Thanks for your reply. This helps. When I do the unpivot of the columns, I get:
How do I get the values and the dates from the value column in 2 separate columns?
Thanks in advance...
I filtered by date so could use contains "/" to make the date table. Then I copied the query and filtered by does not contain "/" to get the values, then I merged by date AND column number (attribute) to get the final table.