Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

dpietersz
Contributor

Re: Different results from same load-string?

I don't understand the 2 different ways of concatenating.

Could you post the 2 different scripting approaches you mean.

If you still have the problem without synthetic tables, than it has to be in one of the steps you do.

You can be sure of this if you make a new clean .qvw and load only one table at the time. My guess is that will show the correct data.

You could also try to see if there is a difference in the cell properties of the 2 excel files.

Highlighted
siepe1990
New Contributor III

Re: Different results from same load-string?

1st Concatenate way:

- Load Table 2011 data

- Load Table 2012 data

- Load Table with HeadQuarter data

- concatenate Table 2011 data with Table HQ-data

- concatenate Table 2012 data with Table HQ-data

2nd Concatenate way:

- Load Table 2011 data

- Load Table 2012 data

- concatenate Table 2012 data with Table 2011 data

1st way gives the double data

2nd way only gives single data, as it should be...

Complicated for me to explain this clearly to you all I'm afraid 😞 Think I'll try the table for table approach you suggest...

dpietersz
Contributor

Re: Different results from same load-string?

I beginning to understand it. Don't worry, it's always hard to explain these things via internet 😉

You can use the function "exit script;" between your load statements to see if everything is working as it should be.

Maybe QlikView automaticllay does a concatenation which you don't expect. If your load state has exactly the same column names as a previous load statement QlikView will concatenate it for you. If you don't want this you can use "noconcatenate load" instead of "Load".

siepe1990
New Contributor III

Re: Different results from same load-string?

I reload once more, and everything works... I didn't change a thing...

This is very, very strange...

Well, thanks for the help Dimitri, much appreciated 🙂

dpietersz
Contributor

Re: Different results from same load-string?

Your welcome!

Good luck!!