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

Combine script tabs to one tidy tab without original source

QlikWendy1 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

MK9885 — Mon, 09 Jul 2018 17:02:46 GMT

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?

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

QlikWendy1 — Thu, 12 Jul 2018 15:11:03 GMT

Dear Shahbaz,

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

Best,

Kelly