Forum Discussion
Unpivot columns and convert to date?
So I don't see anywhere that I can attach a file so I'll have to use excel screenshots to show my example. The first screenshot below is an example excel workbook of how the data will be brought into...
Hi Anonymous,
After test, the solution RolandsP posted is right. After unpivot all columns, you will get the following data.
Then select the [Attribute] click Split column by delimiter (Select "space" and right-most delimiter) as follows, you will get expected result.
Best Regards,
Angelia
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
After test, the solution RolandsP posted is right. After unpivot all columns, you will get the following data.
Then select the [Attribute] click Split column by delimiter (Select "space" and right-most delimiter) as follows, you will get expected result.
Best Regards,
Angelia