Forum Discussion

ArvindJha's avatar
ArvindJha
Icon for Helper III rankHelper III
1 year ago
Solved

Additional columns in some files Folder Connection

Hello Team,

 

I am using Folder connection and combining multiple files , the problem is some files contain additional columns like CREATEDBYUSERID , while creating Transform Sample File it is not coming.

I want to have a logic where have the column CREATEDBYUSERID with null values when column is not present in the file.

 

Thanks

Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi ArvindJha 

     

    The column names are dependent on the transform file used the by combine files feature which is usually the first one the query editor sees.

    You can modify the formula in that step to add an extra row to the list of column names using List.Combine

    = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (2)", List.Combine({Table.ColumnNames(#"Transform File (2)"(#"Sample File (2)")), {"Extra Column"}}))

     

     

     

2 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    1 year ago

    Hi ArvindJha 

     

    The column names are dependent on the transform file used the by combine files feature which is usually the first one the query editor sees.

    You can modify the formula in that step to add an extra row to the list of column names using List.Combine

    = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File (2)", List.Combine({Table.ColumnNames(#"Transform File (2)"(#"Sample File (2)")), {"Extra Column"}}))