Logic Help

[abhaysingh]

Hi Guys,

I need small help here,

i have on table in which fileds are let say GLCode, PFCentre  both have values in it like 22222, 1001 etc and a amount

i want to append composite key of GLCode, PFCentre below the GLCode

for eg

GLCode    

22222,

22222|1001

so now you can see it has two record in GLCode.. I want to do this in single table so that w.r.t . value 22222|1001 i can able to get amount as well, Possible?

thanks

[Chanty4u]

LOAD *,

GLCode& '-' & '-' & PFCentre as GLcode,

[Anonymous]

may be like this?

Load

GLCode

...

Concatenate

Load

GLCode&'|'&PFCenter as GLCode

[abhaysingh]

in that case i can able to get the amount

[sunny_talwar]

so you said they need to have amount? what amount would it show (the second row)? sum of 22222 and 1001 or just amount related to 1001?

[abhaysingh]

Hi Suri i want to append the value of two different field into one, this is what i want

[puttemans]

Hi there,

Can you get a small example of what you need? I suppose you have the key, and then a separate field with the amounts. what do you want the amounts to do? Duplicate? Sum?

Kind regards,

Johan

[Anonymous]

What exactly you want to achieve?

Say amount is 100

GLCode, Amount
22222,    100

22222|1001, 100 or Blank??

[abhaysingh]

GLCode, Amount
22222,    100

22222|1001,   it may change, w.r.t 22222 GL code the value is 100 w.r.t different PFCentre, so out of so many profit centre 22222|1001 have some value let say 10, i want to pick 10

[Anonymous]

sample Data?