Correction Left Join

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Correction Left Join

boorgura — Thu, 12 Apr 2018 19:13:05 GMT

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)