Forum Discussion
Function to Filter Sharepoint files from Folder
I am hoping someone could determine if this is even possible? I am given excel files that have certain date ranges based on worker information. The date ranges in the files will overlap because somet...
It might be simpler to do a full crossjoin and then for each data row pick the "newest" file.
Maybe provide some more sample data?
Thanks. Let me think about how I could provide some addtional samples of data. I think the real challenge is I will be calling a function to be run against a sharepoint folder and have it recognize this logic some how. So as we expand rows on the actual file it knows that it needs to exclude certain rows.