Forum Discussion

jpt1228's avatar
jpt1228
Icon for Responsive Resident rankResponsive Resident
9 years ago
Solved

Create Date Column from cell in data file

Hello, I have a monthly data file that I want to import into my model. The file needs to reference the date for the data. The file name does not have a date so I need to take the beginning part of th...
Need Help
  • ImkeF's avatar
    ImkeF
    9 years ago

    How about filtering that table on [Column1]= "Date Range" ?

    Split Column 2 with "to" as delimter then.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Are you using a Folder query? I would look at perhaps creating a Function to grab this and then integrating that into your overall query for importing each file.