Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Adding attributes to loaded files in-script

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.

1 Solution

Accepted Solutions

Re: Adding attributes to loaded files in-script

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

2 Replies

Re: Adding attributes to loaded files in-script

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

Not applicable

Re: Adding attributes to loaded files in-script

Single quotes! Of course. Thank you Miguel.

Community Browser