Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate Value Problem

Hello Community,

I have a little problem with duplicate values :

Here is a example of my probleme  : i have 2 tables :


Table 1 :


Table 2 :

When i load these two table i get :

My problem is the NULL in Field width and weight of the A1 (code product) .

I want to have all values i.e. two row for A1.

Somebody knows a solution?

Thanks.

1 Solution

Accepted Solutions
jagan
Partner
Partner

Hi,

Try like this

Dimension: CodeProduct, Length, width, Weight

Expression Name: Dummy

Expression: 1

Now in Presentation tab select Dummy column and select Hide Column option.

Hope this helps you.

Regards,

Jagan.

View solution in original post

15 Replies
sunny_talwar

What is the script that you are using right now? I don't see why the values will become null with your current sample. I think we will get more information when you share the script you are using to merge the table?

Not applicable
Author

Hi Sunny,

I just do a LOAD that two tabble

But i missed somting, the problem appear when i create a straight table with Code Product as dimension and others field  as expressions.

you understand?

sunny_talwar

Are you doing this?

Table1:

LOAD stuff

FROM Table1;

Table2:

LOAD stuff

FROM Table2;

or

Table1:

LOAD stuff

FROM Table1;

Join (Table1)

LOAD stuff

FROM Table2;

or

Table1:

LOAD stuff

FROM Table1;

Concatenate(Table1)

LOAD stuff

FROM Table2;

Not applicable
Author

I did that  :


Table1:

LOAD stuff

FROM Table1;

Table2:

LOAD stuff

FROM Table2;

maxgro
MVP
MVP

see attachment

1.png

sunny_talwar

Here is what I got when I use what you just mentioned:

Table1:

LOAD * Inline [

Code Product| Length| Width| Weight

A1| 3| 6| 9

A2| 2| 4| 8

B1| 2,5| 5| 10

B2| 1| 3| 4

] (delimiter is |);

Table2:

LOAD * Inline [

Code Product, Length, Width, Weight

A1, 3, 6, 9

B3, 9, 6, 4

B4, 5, 7, 11

B5, 3, 7, 12

];

Output in a table box object:

Capture.PNG

Not applicable
Author

excuse me i forgot something, in fact the two table looks likte that


A1 has not the sames value for all field in the two table, and i get that

Thats the problem

Not applicable
Author

excuse me i forgot something, in fact the two table looks likte that


A1 has not the sames value for all field in the two table, and i get that

Thats the problem

sunny_talwar

What is your intended output?