You are not logged in.

Problems with Normalization

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Jimm

Intermediate

  • "Jimm" started this thread

Posts: 5

Date of registration: Apr 12th 2012

  • Send private message

1

Friday, August 3rd 2012, 1:12pm

Problems with Normalization

Hi everybody,

i've a problem with my ETL project, i've this structure:

Column1 | Column2 | Measures | Value
Data | Data | Units | 2
Data1 | Data | Euros | 120

So i'm trying to create the measures dimension, So in my transform i put the following:

Mode: Normalization
Normalizer field: Measures
Value field:


Measures:
Euros | Value
Units | Value

But i'm getting this result in the preview:

Data | Data | Units | 2
Data | Data | Euros| 2
Data | Data | Units | 120
Data | Data | Euros| 120

How can I solve my problem? Thank you very much, and sorry for my bad english :D

kratzer

Master

  • "kratzer" is male

Posts: 87

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

2

Sunday, August 5th 2012, 3:24pm

In my understanding you need normalization only if your values are in different columns, but yours are already in the column "value".

Jimm

Intermediate

  • "Jimm" started this thread

Posts: 5

Date of registration: Apr 12th 2012

  • Send private message

3

Wednesday, August 8th 2012, 12:21pm

Thank you very much for your answer.

I just had to select the "Only Aggregation/Projection" Mode in my tabletransform, cause i had the correct field structure.

Have a nice day!

Similar threads

Rate this thread