Create Field in one table By using field in another table.

[#1]

I have an inline :

items id , item descriptions,

1, Purchase

2,Sale

3,etc

4,Others Reciepts/issues

5,Other Reciepts/Issues

6,..

And I also have another table in which i  Got details of quantities.

where quantities have both Negetive and positive values .

Now i need

To Give them quantity details either purchase , or sale or other reciept or issues .But for issues and reciepts, i have to distinguish on the basis of their quantity and id if id is 4 and quantity positive reiciept other wise issues.. please help me. than you.

Here is the attachment also.

Message was edited by: sandeep subedi

[sujeetsingh]

Sandeep ,

you need to use nested if gor checking the conditions whether to take Reciepts or Issues.

Well can you provide the sample or explain in detail

[tresesco]

I guess you are using applymap(). Try using an IF along with the applymap for such exceptional cases, like:

If(ID=4 , If(Qty>0,'Reciept' , 'Issues'), ApplyMap( 'MapTable' , ID)) as QtyDetails

[#4]

I have attached one eg above. please Sir , have a look at it once.

[#5]

Hey sundeep,

do like this then you will get the quantity also

Quantity:

Mapping

LOAD ID,

     QTY

FROM

C:\Users\rb4\Downloads\EG.xls

(biff, embedded labels, table is [Sheet1$]);

Consolidated:

LOAD ID,

     NAME,

     ApplyMap('Quantity',ID) as Quantity

FROM

C:\Users\rb4\Downloads\EG.xls

(biff, embedded labels, table is [Sheet 1$]);

Regards,

Rajesh

[#6]

In this way I will get  purchase , sales , but if i need to distinguish misc reciept or issues that i need to do on the basis of quantity being positive or negetive. how can i solve it out.

[#7]

Please reply me .