Duplicate Value Problem

[#1]

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.

[jagan · Accepted solution]

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]

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]

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

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]

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]

this is the result with the .qvw in the attachment

[Gabriel]

Hi,

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