Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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).
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?
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 ?
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).