Issue

[subbareddykm]

Hai all good eve to all,

i have one requirement,Can any any one tell me how to do this in backend .

Please find below attchment for reference.I want new field like screenshot

[Anonymous]

do like this?

Load * inline

[Project, Subproject, NewField

A,1234, qwe

A, 2345, fgh

and so on....

];

[sunny_talwar]

May be try this:

Table:

LOAD Project,

          Sub Project

FROM Source;

FinalTable:

LOAD *,

          If(Project = Peek('Project'), RangeSum(Peek('NewField'), 1), 1) as NewField

Resident Table

Order By Project;

DROP Table Table;

UPDATE: Missed a single quote after Project field within Peek

[avinashelite]

what's you requirement ?? you want to create a table in the script ??

could you please explain your requirement

[sunny_talwar]

I am assuming that it is to create the NewField in the image , But I may very well be wrong here

[avinashelite]

No , Bro ..I think that might be the requirement ... lets wait for the reply

[subbareddykm]

Sunny,

what i want is my output field is New Field.How to acheive that ?

[avinashelite]

did you check the previous post by Sunny ??

[sunny_talwar · Accepted solution]

Try this:

DATA:

LOAD Project,

    [Sub Project]

FROM

[ACCUMILATION.xlsx]

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD *,

    If(Project = Peek('Project'), RangeSum(Peek('NewField'), 1), 1) as NewField

Resident DATA

Order By Project;

DROP Table DATA;

[vikasmahajan]

HTH

Vikas