Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

INSERT is Not Working for Inline

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
18 Replies
amit_saini
Master III
Master III

This might help u:

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

Thanks,
AS

ramasaisaksoft

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

Anil_Babu_Samineni
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Digvijay_Singh

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

Anil_Babu_Samineni
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tyagishaila
Specialist
Specialist

LOAD * INLINE [

    EmpName, Sal

    A, 1000

    B, 2000

    C, 3000

];

Concatenate

LOAD * INLINE [

    EmpName, Sal

    D, 100

    B, 200

    C, 3000

];

OR

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.

Digvijay_Singh

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.

Anil_Babu_Samineni
Author

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.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
amit_saini
Master III
Master III

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

Thanks,

AS