topic Re: merging table fields in QlikView

merging table fields

Thu, 04 Oct 2012 13:46:15 GMT

Hi,

Im fairly new to Qlikview so I imagine this is a very simple question.

I have loaded two worksheets from a spreadsheet into QV which display the same data but for two seperate organisations. One of the fields on each worksheet is a number for the cost of 21 different items but the heading for this is different on each worksheet e.g "Cost company 1" & "Cost company 2".

When I try to create a table in QV to show these items and their costs for each company it duplicates the item rows. how do I get one row for each item with the two costs shown next to it?

I currently have this:

Item	Cost Company 1	Cost Company 2
Item 1	350
Item 1		250
Item 2	360
Item 2		240

And would like this:

Item	Cost Company 1	Cost Company 2
Item 1	350	250
Item 2	360	240

Any help is greatly appreciated

Thanks

Re: merging table fields

Gysbert_Wassenaar — Thu, 04 Oct 2012 13:57:21 GMT

Looks like you concatenated your tables. Try using join instead. See http://community.qlik.com/thread/39177 for a bit more explanation on join, keep and concatenate.

Re: merging table fields

Thu, 04 Oct 2012 14:04:49 GMT

Thanks for the fast response.

That looks like exactly the problem. From looking at the thread you suggested I think I need an Outer Join. How do I make this happen? In the Script?

Thanks

Re: merging table fields

Thu, 04 Oct 2012 14:07:36 GMT

Do it in the script

Load Item

[Cost Company 1]

From csv1

LEFT JOIN

Load Item

[Cost Company 2]

From csv2

Or something like that...

Re: merging table fields

Thu, 04 Oct 2012 14:16:44 GMT

Hi,

Thanks for this.

LEFT JOIN just keeps company 1 value.

I almost need a LEFT & RIGHT JOIN dont I!!

Im probably doing something wrong. Apologies

Re: merging table fields

Thu, 04 Oct 2012 14:19:35 GMT

Im not too sure without looking at it...

Perhaps a simple concatenation would work better.

Could you post your file and let us take a look?

Re: merging table fields

Thu, 04 Oct 2012 15:47:34 GMT

Sorry for the delay

I have been trying to anonomyse the data due to the highly confidential nature of the data but when i do it works! which would obviously be no use.

I had originally thought it might be something to do with the item descriptions i have but have drawn a blank

I will continue to try and upload an anonomysed version for you to see

Thanks