Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

combination of 2 tables with partly same fields

Ok boys, I have an (beginner level) issue.

I have 2 different tables, which in fact should become 1 table (so with join or concatenate I guess). But I get error messages all over the place when I try to do it.

So I have 6 common fields (please look at attachment) :

Month

Year

Period

Business Segment

Unit

Source Cat

P

M

furthermore i have a few individual fields like Flag etc

so for the productgroups, i use for the one table a crosstable and the other one is a straight one, that's no problem.

But now I want to get them into one table: common fields nice in eachother and the empty fields zero

But it doesnt work

Most probably I do lots of stuff wrong, can somebody help me please?

1000x thanks

1 Reply
Not applicable

combination of 2 tables with partly same fields

Hi Giobenoni.

When you perform a cross table, the parameters in it specify:

1: "attribute field" : the name of the field that contains the "old" field names, ie in your case I guess the name of the field that will contain {"prodgroup1", "prodgroup2"...} as values.

2: the data field, which contains the old values that were in this field.

3: the number of preceeding columns to ignore.

The issue with your code is that you have asked qlikview to call the attribute field "Year", whicis will cause problems because it is already a field that is there. Since you would like to match this field to the [Product Group] in the second table, specify it the same name in the crosstable, So it should look like:

crosstable([Product Group],Data,9)

Load....

Qlikview will only concatenate if the two tables have the two sets of fields the same. To "force" concatenate, use the concatenate prefix in the load script:

concatenate(tblMarketStock)

Load.....

Data in a field will be set to null for table data that does not have this field in common.

Is this what  you are after?

Regards,

Erica