Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sfysfy313
New Contributor

Combine script tabs to one tidy tab without original source

Hi everyone,

I've been given a qvd file that has many script tabs(and dashboards are already finished), but without original data source. Now I was asked to combine all these tabs into a tidy one. #

The problem are:

1. Since we don't have original data, how do we know if we combine them successfully(because we cannot reload the data).

2. The process of making the scripts is adding data continuously, and the previous data is commented automatically.

So, How to combine them correctly regarding these problems?(like make the right joins and identify and delete the unnecessary parts)

Many thanks

2 Replies
Khan_Mohammed
Honored Contributor II

Re: Combine script tabs to one tidy tab without original source

You do not have the QVD's? Is this the Raw extract data or transformed data load?

Just Cut and paste the tables in Tab 1 and Click SAVE button on top (Do not load it), move it to QMC> and reload it from there?

Replicate same joins for the tables as you had previously

It would automatically fetch the QVD's or from the original data source.

If you can paste your scripts here or an image then we can help better?

sfysfy313
New Contributor

Re: Combine script tabs to one tidy tab without original source

Dear Shahbaz,

Hi! Thanks for your quick reply! I got data source and solved this problem.

Best,

Kelly