Creating new dimension in load editor (not working)

[ToinkToinkTigger]

Hi everyone,

I am trying the create a new dimension in the load editor.

Line 15 makes sure it extracts only the numerical values from the field as stores it as ''PMPNorm''

Then when trying to create a new dimension (Line 23) Where I add two fields I get the error code ''cannot find PMPNorm''.

When doing this via the data manager it does work, same line of code...but I rather have the code not in an automated load editor. What am I missing here?

Thanks in advance

[rubenmarin · Accepted solution]

Hi, you can't use a field that is not yet created, you can use precedent or lresident load to use the generated field, ie:

PMPData:
LOAD
  *,
  [PMP Ass...]*[PMPNorm] as [PMPScheduled] // Uses the creted field
;
LOAD
  "Item ID" as PMPID,
  Subfield.... as PMPNorm //Create new field
  ...
FROM [lib...];

[curiousfellow]

both dimensions used on line 23 are not available in this part of the script. So you should load it in an other part 

PMPData_2:

Load *,

PMP Assignmentdate + pmpnorm as PMPScheduled

Resident PMPData;

Besides that : A date + the character P ?

[ToinkToinkTigger]

Thank you, that worked!

So now that it is in 'reversed order'

If I want to recognize the field as a date field, where do I add that line of code? do I add it below PMPData:? with another LOAD statement? or can I add the code under LOAD*?

[rubenmarin]

'reversed order'?: kind of, but the order is the same as sql or other loads:

LOAD fieldnames;
SQL Select ....

So basically each load uses the data loaded in the instruction below.

You can use the date in the ame instruction:

LOAD
  *,
  Date([PMP Ass...]+[PMPNorm]) as [PMPScheduled] // Uses the creted field
;
LOAD ...