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.

[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?

[#3]

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;

[#5]

I did that  :

Table1:

LOAD stuff

FROM Table1;

Table2:

LOAD stuff

FROM Table2;

[maxgro]

see attachment

[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:

[#8]

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

[#9]

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?