topic How to manually Insert Data into Table? in QlikView

How to manually Insert Data into Table?

Mon, 25 Jul 2016 08:12:14 GMT

Hey all,

in the script editor, while loading I want to add lines to a (inlined) table.

At the moment I'm doing this via the concatenate command like this:

sub LogDb (pMessage)

let vLogDate = timestamp(now(), 'DD.MM.YYYY hh:mm:ss.ff');

Concatenate(LogTable)

Load * inline [

MessageDate, Message

$(vLogDate), $(pMessage)

];

end sub;

This seems pretty clunky. I wondered if there is something like an INSERT or APPEND command, but couldn't find any in the documentation nor any apropriate discussion here in the community.

So my question: Is this the way you do it, or is there a different (better) way to achieve that?

Kind regards

Sebastian

Edit: clearified scope

Re: How to manually Insert Data into Table?

Digvijay_Singh — Mon, 25 Jul 2016 09:03:25 GMT

Do you need something like below in Insert menu of script editor?

Insert-->Load Statement-->Load Inline

Re: How to manually Insert Data into Table?

Mon, 25 Jul 2016 10:01:48 GMT

Hey,

no, not really, I'm just asking, if there is a more viable way then creating a new inline table and concatenating it with the existing one. Something like a "INSERT" command in SQL.

Thanks for your answer though.

cheers

sebastian

Re: How to manually Insert Data into Table?

Digvijay_Singh — Mon, 25 Jul 2016 10:16:44 GMT

don't think so AFAIK for the data created in script. Let us hear from other experts though!