topic Re: Duplicate Value Problem in QlikView

Duplicate Value Problem

Thu, 13 Aug 2015 08:12:30 GMT

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.

Re: Duplicate Value Problem

sunny_talwar — Thu, 13 Aug 2015 08:21:00 GMT

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?

Re: Duplicate Value Problem

Thu, 13 Aug 2015 08:30:11 GMT

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?

Re: Duplicate Value Problem

sunny_talwar — Thu, 13 Aug 2015 08:32:55 GMT

Are you doing this?

Table1:

LOAD stuff

FROM Table1;

Table2:

LOAD stuff

FROM Table2;

Table1:

LOAD stuff

FROM Table1;

Join (Table1)

LOAD stuff

FROM Table2;

Table1:

LOAD stuff

FROM Table1;

Concatenate(Table1)

LOAD stuff

FROM Table2;

Re: Duplicate Value Problem

Thu, 13 Aug 2015 08:37:38 GMT

I did that :

Table1:

LOAD stuff

FROM Table1;

Table2:

LOAD stuff

FROM Table2;

Re: Duplicate Value Problem

maxgro — Thu, 13 Aug 2015 08:47:17 GMT

see attachment

Re: Duplicate Value Problem

sunny_talwar — Thu, 13 Aug 2015 08:49:55 GMT

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:

Re: Duplicate Value Problem

Thu, 13 Aug 2015 08:57:36 GMT

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

Re: Duplicate Value Problem

Thu, 13 Aug 2015 08:57:50 GMT

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

Re: Duplicate Value Problem

sunny_talwar — Thu, 13 Aug 2015 09:00:05 GMT

What is your intended output?

Re: Duplicate Value Problem

jagan — Thu, 13 Aug 2015 09:04:59 GMT

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.

Re: Duplicate Value Problem

ogster1974 — Thu, 13 Aug 2015 09:06:30 GMT

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;

Re: Duplicate Value Problem

sasiparupudi1 — Thu, 13 Aug 2015 09:27:25 GMT

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

];

Re: Duplicate Value Problem

antoniotiman — Thu, 13 Aug 2015 09:45:11 GMT

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

Re: Duplicate Value Problem

maxgro — Thu, 13 Aug 2015 12:39:23 GMT

this is the result with the .qvw in the attachment

Re: Duplicate Value Problem

Gabriel — Thu, 13 Aug 2015 12:43:18 GMT

Hi,

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