Correction Left Join

[brunopaulo]

Hello community,

I'm doing the following question.

Table1:

Load

     Field1,

     Field2,

     Field3,

     Value

From File;

Left Join (Table1)

Load

     //keys

     Field 1,

     Field 2,

     Field3,

// dimensions

     Field4 as Field 99

From File;

Now my problem is when i get a pivot table with

Field 1, Field2, Field,3 and Field99 my value is replicate by the number of times i get field99.

Example

i have 4 times field99 the value i get is Value*4. And i only want 1 time this Value. 

What im looking value only.

I'm trying solve in script anyone has ideas how to do it?

Best Regards

Bruno Paulo

[boorgura]

How do you want the Value to be split against Field99's 4 values.

Lets say the record is

F1, F2, F3, 100

And second table has

F1, F2, F3, x1

F1, F2, F3, x2

F1, F2, F3, x3

F1, F2, F3, x4

as the rows.

Obviously when you do a left join you will see 100 in all 4 rows.

If that's not what you want to see - how do you intend to pivot the 100 against Field99 (meaning what should be split of 100 for x1, x2, x3 and x4)