Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rocioaliagaisla
New Contributor

What is REM in Load Statement?

Well, I am new using Qlik Sense, so, @

I woud like to know what does REM works in Load Statement?

Thanks!

REM LOAD IDBudget,

    Année,

    Mois,

    Budget;

SQL SELECT IDBudget,

    Année,

    Mois,

    Budget

FROM "C:\Users\Rocio.ALIAGA\Desktop\DATA-FORMATION QLIKSENSE\BDD\Budget".Ventes;

Tags (2)
4 Replies
felipedl
Valued Contributor III

Re: What is REM in Load Statement?

Hi Rocio,

It's more like a comment, see the following link:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/...

If you use the statement as you posted, it will get an error since it will understando somethin like this:

// LOAD IDBudget,

    Année,

    Mois,

    Budget;

SQL SELECT IDBudget,

    Année,

    Mois,

    Budget

FROM "C:\Users\Rocio.ALIAGA\Desktop\DATA-FORMATION QLIKSENSE\BDD\Budget".Ventes;


Basically the "REM" is equal to the "//"

sunilkumarqv
Valued Contributor II

Re: What is REM in Load Statement?

Rem ** This is a comment **;

/* This is also a comment */

// This is a comment as well

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularS...

MVP
MVP

Re: What is REM in Load Statement?

Actually the REM statement is NOT equal to //.

Because the REM statement is a FULL statement comment that can stretch over more than one line until a semicolon.

So it is really a cross between a // and a /* ......   */.

Can be very handy.

MVP
MVP

Re: What is REM in Load Statement?

It comments out then entire LOAD statement. Not just the first line but all the lines until the end of the LOAD statement.

REM is short for remark which is similar to comment. It is common in various dialects of BASIC since the dawn of time.

Community Browser