Hey guys,
I've used this great community many times and unfortunatly this time I couldn't find solution for my issue so I'm turning for help.
There are files coming every one week to one folder with pivoted data, something like this:
At the beginning I thought it was easy, I have used Expanded tables function so I got all the data form this folder in one query and then just used Unpivot function. It would work..but the data that is pivoted is very often different, see example below:
Example1:
| Date | City | ProductID1 | ProductID2 | ProductID3 |
| A | B | value | value | value |
Example 2:
| Date | City | ProductID1 | ProductID3 |
| A | B | value | value |
In the above example, if we will Unpivot appended data it would give us false values (joining productID2 with productID3).
I need some kind of solution that will create for each file separated query and then will append all the queries together. Each file needs to be unpivoted separately, I can't think of anything else.
Anyone had situation like that?
Would be grateful for help.
Cheers,
Rafal
