I was looking for a way to create an SQL table from an existing Qlikview table. The script is a bit complicated with me loading into Qlikview from SQL and the necessity to do vice versa but I can't see any other way but going back to SQL.
I created a table "temp" joining lots of fields from different database tables. Ideally I need to extract a few fields from there so that I could work with the SQL table from that point on. Or it'd be simpler if I just worked with SQL from the very beginning i.e. loaded tables in SQL instead of Qlikview?