Kwalling All Informatica Guys

[warr49er]

[jaffanajeffada]

aa vacham... emi help kaavali?

[Terminator II]

cheppu...

[mtkr]

em help caaaallll aaa ?? supporrt aa?? endho cheppakunda help enddiii??

[ganesh]

[warr49er]

oka doubt...

if mfr = na, then count+
and if family = na, then count+
and if grp = na, then count+
else count = 0
dqp = (count/3) * 100

Count is the variable i want to use...

ee stantement ni exp transformation lo ela cheyyalo telitam ledhu...
help please

[jaffanajeffada]

1. first oka variable port open chey(name: v_PORT1) ... danilo, IIF(mfr=na, count +1)
2. Create 2nd variable port , v_PORT2, IIF(family = na, v_PORT1 +1)
3. Create 3rd variable port , v_PORT3, IIF(grp = na, v_PORT2 +1, 0)
4. Now create output port , o_OUTPORT1 = v_PORT3/3 *100

Note: for steps 1 and 2, else condition emanna unte danlo rasukoo

[ganesh]

aggregator vadu...akkada count teesukoni expressions lo variable ports teesukoni calculations perform chesukoo

[ganesh]

[quote name='jaffanajeffada' timestamp='1337193805' post='1301808959']
1. first oka variable port open chey(name: v_PORT1) ... danilo, IIF(mfr=na, count +1)
2. Create 2nd variable port , v_PORT2, IIF(family = na, v_PORT1 +1)
3. Create 3rd variable port , v_PORT3, IIF(grp = na, v_PORT2 +1, 0)
4. Now create output port , o_OUTPORT1 = v_PORT3/3 *100

Note: for steps 1 and 2, else condition emanna unte danlo rasukoo
[/quote]okee variable port lo 3 conditions test cheste saripoddi anukunta

[warr49er]

thanks guys....work aithundo ledho update chestanu....ee lopu meeru rounds velli randi....

[ganesh]

[quote name='warr49er' timestamp='1337194160' post='1301809026']
thanks guys....work aithundo ledho update chestanu....ee lopu meeru rounds velli randi....
[/quote]babu me vallu ninu override use cheyoddanara?

[jaffanajeffada]

[quote name='ganesh' timestamp='1337194131' post='1301809021']
okee variable port lo 3 conditions test cheste saripoddi anukunta
[/quote]

count anedhi column anukuntunna bayya, aggregate value kaadhu ani anipistundhi!!

three conditions apply avvali ante 3 variable ports kaavali kadha!! i mean, first condition apply ayinappudu count value okati untundhi, and second condition kooda match aithe first condition unna value ki 1 add cheyyali kadha... aa case lo multiple variable ports kavali ani anukuntunna!

[jaffanajeffada]

[quote name='warr49er' timestamp='1337194160' post='1301809026']
thanks guys....work aithundo ledho update chestanu....ee lopu meeru rounds velli randi....
[/quote]
babu hero, nuvvu ichina req lo count anedhi aggregate function lo unde count aa or just column aa??

[ganesh]

[quote name='jaffanajeffada' timestamp='1337195139' post='1301809201']


count anedhi column anukuntunna bayya, aggregate value kaadhu ani anipistundhi!!

three conditions apply avvali ante 3 variable ports kaavali kadha!! i mean, first condition apply ayinappudu count value okati untundhi, and second condition kooda match aithe first condition unna value ki 1 add cheyyali kadha... aa case lo multiple variable ports kavali ani anukuntunna!
[/quote]nenu ayite count anedi column ani anukovatledu...anduke aggregator use chesi...taruvata expression lo aa value use chesi calculations cheyyamanna [img]http://1.bp.blogspot.com/-vXer8MQYZrM/T1jw_Q2juqI/AAAAAAAAB_g/Upm7DId5ox0/s1600/brahmi+laugh.gif[/img]

[jaffanajeffada]

[quote name='ganesh' timestamp='1337195268' post='1301809233']
nenu ayite count anedi column ani anukovatledu...anduke aggregator use chesi...taruvata expression lo aa value use chesi calculations cheyyamanna [img]http://1.bp.blogspot.com/-vXer8MQYZrM/T1jw_Q2juqI/AAAAAAAAB_g/Upm7DId5ox0/s1600/brahmi+laugh.gif[/img]
[/quote]
lets wait and see babu emantaado...