INSERT is Not Working for Inline

[Anil_Babu_Samineni]

Dear Friends,

I have one inline table like below

Company:

LOAD * INLINE [

    EmpName, Sal

    A, 1000

    B, 2000

    C, 3000

];

I want to add one more row with the Name of D and D salary is 4000.

So, here i am not fetching the data from DB. I am using just inline.

Can anyone help me Logic

SQL INSERT INTO Company(EmpName,Sal) Values ('D',4000);

[Anonymous]

why do you use a SQL function? do you need to get data from a database?

I would use

concatenate (Company)

load 'D' as EmpName,

4000 as Sal

autogenerate 1

but why don't you expand the inline table directly?

[amit_saini]

Hi Anil,

As per my knowledge u should first update ur DB first and than use QlikView.

QlikView is not best as SQL database to insert new records.

But let's wait for experts suggestion

Thanks,

AS

[Anonymous]

As Rudolf asked why can't you simply extend your original inline load to include this extra row. It seems a strange requirement unless you have a specific reason you haven't shared.

[Anil_Babu_Samineni]

Amit, You mean every time i need to update the DB and then reload.

So, here i want to add one more data using INSERT Statement. is that possible?

[tyagishaila]

Hi Anil,

You can add rows (Load Inline or Load from..) by concatenate qvd with new Load.

[Anonymous]

Have you thought of using direct discovery? I may be wrong but maybe this will be useful for you if you need to update from source SQL table.

[Anil_Babu_Samineni]

Sorry, That's my mistake. Actual i am getting data from DB only.

If we are using suck concaatenate, How many times we need to add that?

Let's assume 1 day 100 employees joined with one company that time i want to add 100 times.

MEatime, If 1000 employees salary will updated then i need to write 1000 times. But, here how to update those 1000 salaries using Concatenate.

[amit_saini]

You can for sure.

Add ur new data and concatenate with the old one

Thanks,

AS

[Anil_Babu_Samineni]

I am not sure, That's why i came here.

Anyway, If i am getting That table from DB then i don't want to edit again ion DB

I want to use directy on Qlik using DML / DDL Operations. Is that possible?

Note: i have the access my Database