Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

15 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

ogster1974
Partner - Master II
Partner - Master II

Add a source field to id your source file that will keep your data seperate

Table1:

LOAD

Source, Code Product, Length, Width, Weight

T1,A1| 3| 6| 9

T1,A2| 2| 4| 8

T1,B1| 2,5| 5| 10

T1,B2| 1| 3| 4

FROM Table1;

Concatenate(Table1)

LOAD

Source, Code Product, Length, Width, Weight

T2,A1, 3, 6, 9

T2,B3, 9, 6, 4

T2,B4, 5, 7, 11

T2,B5, 3, 7, 12

FROM Table2;

sasiparupudi1
Master III
Master III

I did what you specified and I got the correct results..May be you are doing some modification to the loads?

Untitled.jpg

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

];

Table2:

load * Inline

[

Code Product ,Length,Width, Weight

A1,3,6,9

B3,9,6,4

B4,5,7,11

B5,3,7,12

];

antoniotiman
Master III
Master III

Hi,

If You have Dimension Code and Expressions Le,WI,We in Straight (or Pivot) Table

You achieve Null value because several values in Wi/We

You can use Dimensions Code,Le,Wi,We Like this

Regards,

Antonio

maxgro
MVP
MVP

this is the result with the .qvw in the attachment

1.png

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

You need the clause CONCATENATE in-between the 2 tables.