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: 
dseelam
Creator II
Creator II

Add new field with history to existing QVD

Hello All,

how do I add new field with history to my old QVD which I am using right now in my daily dashboard (data model)

1 Solution

Accepted Solutions
swuehl
MVP
MVP

That might depend on how you want to process the data further on.

Here is an explanation of how a JOIN works vs. CONCATENATE.

It may also be possible to just keep the tables linked in the data model (separate tables, linked by common key field).

Understanding Join, Keep and Concatenate

View solution in original post

3 Replies
swuehl
MVP
MVP

Could you elaborate a bit more detailed what you are trying to achieve? Maybe may posting some sample lines of records how your QVD table looks like and how your new data looks like and how you want to 'merge' the table sources?

dseelam
Creator II
Creator II
Author

Stefan,  Thank you for your reply

I have  a QVD with 50 columns and I want to add a new record with contract type as a 51st column

both of them have a primary key item id

how can i do this just left join  or add?

what if I don't have primary key ? is it possible to just append the data ?

swuehl
MVP
MVP

That might depend on how you want to process the data further on.

Here is an explanation of how a JOIN works vs. CONCATENATE.

It may also be possible to just keep the tables linked in the data model (separate tables, linked by common key field).

Understanding Join, Keep and Concatenate