Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Custom Column Expand Creates Duplicates

Hey,   I'm bringing in files from a folder: - File 1 - File 2 - File 3   I add a custom column formula: - Excel.Workbook([Content], true)   I expand the custom column formula and the output...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Sorting them into files is a great idea, however it would require me to rely on users which I would prefer not to do ;) Combine and edit produces different results than what are needed.

     

    I did find a couple of the reasons for why it duplicates the file. If there is a filter applied in the file then it duplicates the file, so removing any files where name contains FilterDatabase is one step. Where there are multiple options for Kind, removing any that contain DefinedName and leaving all null or sheet also seems to work.

     

    Unsure if these are permanent solutions or not but they work for now.

     

    Thank you for your help!