topic Re: Creating new dimension in load editor (not working) in App Development

Creating new dimension in load editor (not working)

ToinkToinkTigger — Wed, 02 Nov 2022 10:29:03 GMT

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

Re: Creating new dimension in load editor (not working)

rubenmarin — Wed, 02 Nov 2022 10:32:10 GMT

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...];

Re: Creating new dimension in load editor (not working)

curiousfellow — Wed, 02 Nov 2022 10:47:09 GMT

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 ?

Re: Creating new dimension in load editor (not working)

ToinkToinkTigger — Wed, 02 Nov 2022 11:01:52 GMT

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*?

Re: Creating new dimension in load editor (not working)

rubenmarin — Wed, 02 Nov 2022 11:07:55 GMT

'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 ...