Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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;
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
];
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
this is the result with the .qvw in the attachment
Hi,
You need the clause CONCATENATE in-between the 2 tables.