topic Adding attributes to loaded files in-script in QlikView

Adding attributes to loaded files in-script

Wed, 05 Sep 2012 12:23:13 GMT

Hello,

I was wondering if it was possible to insert extra attributes into records when they are being loaded. The equivalent in a SQL pull would be like adding:

"TEXT" as record_type

to a select clause.

Re: Adding attributes to loaded files in-script

Miguel_Angel_Baeyens — Wed, 05 Sep 2012 12:25:18 GMT

Hi,

Use the LOAD sentence to do that:

Customer:
LOAD CustID,
     CustName,
     'Customer' AS Type; // this is not in the SQL server
SQL SELECT CustID, CustName
FROM dbo.Customers;

Is that what you mean?

Miguel

Re: Adding attributes to loaded files in-script

Wed, 05 Sep 2012 12:54:24 GMT

Single quotes! Of course. Thank you Miguel.