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

[amit_saini]

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]

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

[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]

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

[tyagishaila]

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]

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.

[amit_saini]

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

Thanks,

AS