Forum Discussion

cool_333's avatar
cool_333
Frequent Visitor
3 years ago
Solved

Issues with date columns

Hi All, I'm trying to solve this issue if anyone can help. I've saved spreadsheets on the SharePoint folder and it has the Activity ID column and date columns please see the below snippet. The issue...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi cool_333 

     

    Are you connecting to the SharePoint folder and combining all files data into a single query? I guess that you have already selected the most recent file as the Sample file and transformed it in "Transform Sample File" query right? If so, you need to add a custom step in the "Transform Sample File" query to select the columns. 

    = Table.SelectColumns(#"previous step", Table.ColumnNames(#"previous step"))

     

    I recommend that you promote the date value row as column header, and remove the auto-generated "Changed Type" step. The "Changed Type" step changes column types based on column names, this will sometimes cause an error when combining multiple queries. Then you can go to the combined single query. If it has an error, remove its auto-generated "Changed Type" step too. You will have the expected combined result then. You can change column types later manually. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi cool_333 

 

Are you connecting to the SharePoint folder and combining all files data into a single query? I guess that you have already selected the most recent file as the Sample file and transformed it in "Transform Sample File" query right? If so, you need to add a custom step in the "Transform Sample File" query to select the columns. 

= Table.SelectColumns(#"previous step", Table.ColumnNames(#"previous step"))

 

I recommend that you promote the date value row as column header, and remove the auto-generated "Changed Type" step. The "Changed Type" step changes column types based on column names, this will sometimes cause an error when combining multiple queries. Then you can go to the combined single query. If it has an error, remove its auto-generated "Changed Type" step too. You will have the expected combined result then. You can change column types later manually. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.