0

I'd like to work with data from 2sxc in Excel (for reporting/analysis purposes). Is it possible to create a query that would create a normal looking view with the fields?

Thanks.

Mike
  • 107
  • 7

1 Answers1

0

Technically this can be done using standard sql, but I can't provide a quick example. You basically need to do pivots. Alternately you could create a html-view and open/link that in excel, this is probably much easier to do.

iJungleBoy
  • 5,325
  • 1
  • 9
  • 21
  • Thanks - I ended up doing a bit of both. I grabbed the entity/value data using an SQL statement, and then used Excel's data query to pivot it into a normal excel table. That worked well for me and avoided having to do a dynamic pivot in SQL. – Mike Aug 08 '16 at 02:22