Forum Discussion

Chris_W17's avatar
Chris_W17
Regular Visitor
3 years ago
Solved

Import files using Folder data source, where individual files may have different column counts and .

Good morning community, I am trying to import files using Folder Data source. Tha files are CSV. The files are outputted daily from an online reporting portal.  The report will only populate a colum...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Chris_W17 Create a calculated column for each of your 12 possible columns. You could use this format:

    try [Column] otherwise null

    After this is done, select your calculated columns and Remove other columns. Then rename your columns.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Chris_W17 Create a calculated column for each of your 12 possible columns. You could use this format:

try [Column] otherwise null

After this is done, select your calculated columns and Remove other columns. Then rename your columns.