on 10-15-2009 2:04 AM
hi...
i want to map these,
1. Sum of <field1> for all <field2 of diff table> = <field2 from diff table> where <filed4> > 900000
2.left justy a field
3.checking condition...
plz help me on this....
thanks...
Hi,
Can you pls expain the mapping requirement in detail?
Specially first condition.
If possible, its better if you can mention your source and target structures as well.
Regards,
Supriya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check this links and follow that mapping
http://www.flickr.com/photos/42898709@N07/4013604333/
Regards
Ramesh
Hi,
What you mean by left justify and checking field? could you please eloborate.
if your input is 5 characters and you need 10 characters at this time you can use Format NUmber predefined function in the mapping. give input to that function and double click on that function and give the total number of characters.
Ex: 200 output: 000200 then you menation 000000 in the format number function.
Regards
Ramesh
Hi,
Use the sub string and concatenate function.
Check this below link
http://www.flickr.com/photos/42898709@N07/4015044928/
Regards
Ramesh
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.