topic Add column to SQL load in QlikView

Add column to SQL load

markf1995 — Sun, 21 Jul 2013 19:24:18 GMT

I am new to qlikview. I am trying to add a column to all records I am loading that identifies the source data wharehouse. In a CSV load I would just right at the end of the colmns - 'Table xxx' as SOURCE - and I would be able to query SOURCE in my visualizations. I can load the data correctly but I don't know how to add this extra column to each record.

OLEDB CONNECT TO [Source ID Properties (all this stuff works)] (XPassword is (all this stuff works));

SQL

SELECT
"Dimension_1",
"Dimension_2",
"Dimension_3",FROM "Data Source"

where Dimension_3 = 20120101;

How do I add a column 'Table xxx' as SOURCE to this data pull that is working ok. Where 'Table xxx' is a field I want to define in the load script.

Thanks!

Re: Add column to SQL load

Sun, 21 Jul 2013 22:31:37 GMT

Hello,

I guess in the case of a simple sql query, such changes can be added directly in the statement.

But usually a preceding load in QV will help you in any needed data transformation, for example:

Table1:

Load field1,

field2,

field1 & ' | ' & field2 as keyfield,

'custom data' as customfield;

SQL SELECT field1, field2 FROM database;

Whenever you connect to your sql db to extract the tables, in the "script" tab, check the "Preceding Load" option so the "load" part comes automatically.

Hope this helps.

Re: Add column to SQL load

markf1995 — Mon, 22 Jul 2013 00:47:15 GMT

You were right I did not clearly understand the role of the preceding load. I researched your answer a bit more and found this link helpful

http://qlikviewnotes.blogspot.com/2009/12/simplify-with-preceeding-load.html

Thanks JP for your quick help!!!