Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
LOAD
bwart,
key_bwart_xblnr,
101_xblnr,
101_Key,
qty,
xblnr,
if(101_Key <> key_bwart_xblnr, 101_xblnr & '=' & qty) as NewField
FROM
...
;
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
Well ... no.
But I assume / hope Gysbert got a better understanding of what you are trying to do.
Create a Flag at script, sth like?
If(101_key=101_xblnr, 'Equal','Not equal') as Flag
And then use Flag value to differentiate..
=10 is what, Qty??
yes
can u build the sample for me?