logic help11

[abhaysingh]

bwart	key_bwart_xblnr	101_xblnr	101_Key	qty	xblnr
641	641|1001	101|1001		10	1001
641	641|1002	101|1002		20	1002
101	101|1005		101|1005	10	1005
101	101|1002		101|1002	20	1002
541	541|1003			30	1003
542	542|1004			40	1004
543	543|1005			50	1005

in this with field 101_key, can i compare 101_xblnr, when they will not equal it will give me, as output 101|1001 = 10

[swuehl]

Sorry, I don't understand that. Could you go through you example line by line and describe what's your input and how you derive your expected results?

[Gysbert_Wassenaar]

LOAD

     bwart,

     key_bwart_xblnr,

     101_xblnr,

     101_Key,

     qty,

     xblnr,

     if(101_Key <> key_bwart_xblnr, 101_xblnr & '=' & qty) as NewField

FROM

     ...

     ;

[abhaysingh]

HI swuehl,

See i have two field 101_xblnr and 101_Key, these are the fields i have created

will following conditions

if(bwart = 641, '101'&'|'&xblnr) as 101_xblnr

and

if( bwart = '101', bwart&'|'&xblnr ) as [101_Key],

now i have two different field in which i want to do the comparison,

you can see the value is coming against , bwart value, 641 and 101... in this i made a change in 641 with 101.

so the final output will come in the form of 101.

now as i asked earlier, after comparing value of two created fields, i.e. 101_xblnr and [101_Key],

in both the fields i have some common value and non common value, non common values are

101|1001 in field 101_xblnr  , in this bwart is 641

and 101|1005 in field [101_Key] , in this bwart is 101.

now final output required when bwart is 641 and non common which is 10 in this scenario.

hope m clear.

thanks in advance

[swuehl]

Well ... no.

But I assume / hope Gysbert got a better understanding of what you are trying to do.

[Anonymous]

Create a Flag at script, sth like?

If(101_key=101_xblnr, 'Equal','Not equal') as Flag

And then use Flag value to differentiate..

[Anonymous]

=10 is what, Qty??

[abhaysingh]

yes

[abhaysingh]

can u build the sample for me?