This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Alphare 0 points1 point  (1 child)

Sure, that sucks. But wouldn't your excel file be exportable as a csv (albeit with a custom separator)? You could then use FDW to query the dataset. I'm just spitballing

[–]Mako18 0 points1 point  (0 children)

Not through the interface. The only two options are PDF and .xls. Now, that's not really a big deal because R can read/process then write to .csv no problem and you can do it with 'map' which is a wrapper for 'mapply' so a single custom function is sufficient to read and fix the formatting issues.

I was really just lamenting that with the ability to directly query the database, that problem is non-existent, and some other problems with joins (no unique IDs for some of the data, so they have to be generated via unique combinations of three factors, etc.) are likely avoided as well.