topic Re: INSERT is Not Working for Inline in QlikView

INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

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);

Re: INSERT is Not Working for Inline

Anonymous — Wed, 20 Jul 2016 06:50:15 GMT

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?

Re: INSERT is Not Working for Inline

amit_saini — Wed, 20 Jul 2016 06:51:05 GMT

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,

Re: INSERT is Not Working for Inline

Anonymous — Wed, 20 Jul 2016 06:52:42 GMT

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.

Re: INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 20 Jul 2016 06:55:04 GMT

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?

Re: INSERT is Not Working for Inline

tyagishaila — Wed, 20 Jul 2016 06:55:28 GMT

Hi Anil,

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

Re: INSERT is Not Working for Inline

Anonymous — Wed, 20 Jul 2016 06:58:41 GMT

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.

Re: INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 20 Jul 2016 06:58:46 GMT

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.

Re: INSERT is Not Working for Inline

amit_saini — Wed, 20 Jul 2016 06:59:06 GMT

You can for sure.

Add ur new data and concatenate with the old one

Thanks,

Re: INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 20 Jul 2016 07:00:55 GMT

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

Re: INSERT is Not Working for Inline

amit_saini — Wed, 20 Jul 2016 07:01:14 GMT

This might help u:

https://community.qlik.com/docs/DOC-7373

Thanks,
AS

Re: INSERT is Not Working for Inline

ramasaisaksoft — Wed, 20 Jul 2016 07:09:51 GMT

Hi Anil,

insert into statement is useful in SQl only,That is a syntax need to follow in sql.

else

may be the below links will help to you.

Can we insert data or records from qlikview to Database

Inserting data into a database

Re: INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 20 Jul 2016 07:10:58 GMT

Yes, I am expecting similar tooo.

1) If i add one more data then i want to effect DB also, Is that possible. Is there any connector from Qlik to DB.

2) If not possible, How do we acheive this

3) If possible, Please send me which connector i need to maintan / Install

4) If we are maintain Inline, how to update using above link. As Rodorf we can do, but client asking me why you want to connect every time to DB. Just check is there any chance to DML/DDL operation in Qlik also?

- ANIL

Re: INSERT is Not Working for Inline

Digvijay_Singh — Wed, 20 Jul 2016 07:14:56 GMT

Hi,

The Core use of Qlikview is to analyse data and help management to take corrective and preventive decisions. Here you are indicating that your data needs frequent changes. The standard way is to do it through script changes or changes in the source system.

When 100 employees joined then surely your transaction system must also change, same is the case when salary is updated, so automatically in next reload the updated data will be loaded in Qlikview or you would need some tweak in script to accomodate new structural changes.

If you try to use Qlikview as your main data repository then you will face many troubles while maintaining it as Qlikview is not made for this purpose.

Thanks and Regards,

Digvijay

Re: INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 20 Jul 2016 07:19:50 GMT

Thanks, Here you mean to say - If we want to update / insert / delete everything happen from DB only, Right? We can't do that operations in Qlik(As i understand). In the below, Sai shared two links in that first link some one replied that, It is possible using macro / Connector. If not possible let me know. If possible, Please give me a solution?

- Thanks

Re: INSERT is Not Working for Inline

tyagishaila — Wed, 20 Jul 2016 07:23:06 GMT

LOAD * INLINE [

EmpName, Sal

A, 1000

B, 2000

C, 3000

];

Concatenate

LOAD * INLINE [

EmpName, Sal

D, 100

B, 200

C, 3000

];

LOAD * INLINE [

EmpName, Sal

D, 100

B, 200

C, 3000

];

Concatenate

Load * from Company.qvd

where not Exists(EmpName); // It is optional depends upon your requirement.

Re: INSERT is Not Working for Inline

Digvijay_Singh — Wed, 20 Jul 2016 07:34:07 GMT

You can use dynamic update( See in button action), also shared in one of the link here to update data loaded in Qlikview but it won't update your DB, so after reload you need to run the action every time. Also I don't think you can do mass update through this in smooth way. I suggest you make updates in your source system and use join/concat etc in your script to reload them in Qlikview.

Re: INSERT is Not Working for Inline

Anil_Babu_Samineni — Wed, 20 Jul 2016 07:38:09 GMT

Yes, I will follow that. But, While reporting the report was not the correct if we follow this.

Might be the best option is DB only. As i understand from this Thread, If we update anything, The DB is not possible with Updated Data. If we updated the data from DB it is possible and reports also Good.

Thanks My all Supporters.

Re: INSERT is Not Working for Inline

amit_saini — Wed, 20 Jul 2016 07:45:34 GMT

Yes for data update or insert ...QlikView is not the best option.

Thanks,