Modify Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi,
My input and output are both strings. The exact statements that I entered was :
1)Latitude:string = NullToValue (Latitude,"NULL")
2)Latitude=NullToValue (Latitude,"NULL")
3)Latitude=NullToValue("NULL")
I also tried NullToZero in the above staments, inside the Modify stage.
But every time, the job log said
unknown conversion: NullToValue/NullToZero
expected field selector,got:")"
When I tried using NullToEmpty, though the job ran, the incoming raw didnt seem to have changed at all.
Can anyone help me with this?
Regards,
Thebird.
My input and output are both strings. The exact statements that I entered was :
1)Latitude:string = NullToValue (Latitude,"NULL")
2)Latitude=NullToValue (Latitude,"NULL")
3)Latitude=NullToValue("NULL")
I also tried NullToZero in the above staments, inside the Modify stage.
But every time, the job log said
unknown conversion: NullToValue/NullToZero
expected field selector,got:")"
When I tried using NullToEmpty, though the job ran, the incoming raw didnt seem to have changed at all.
Can anyone help me with this?
Regards,
Thebird.
handle_null seems to be the way forward here, but in the PX developer pdf, they have a NullToValue example under the modify stage. Surely this function should be available? I'm happy with the work around.
3NF: Every non-key attribute must provide a fact about the key, the whole key, and nothing but the key. So help me Codd.
-
- Participant
- Posts: 5
- Joined: Wed Apr 20, 2005 6:29 pm
- Location: USA
Hi,
Modify Operator does not exactly behave as described in the PX documentation. If you have a chance go through the Orchestrate documentation.
I am doing the same by HANDLE_NULL
This would definitely work.
Stat_Qanty = HANDLE_NULL(Stat_Qanty,0)
Stat_Qanty = HANDLE_NULL(Stat_Qanty,value) for a numeric type
Name = HANDLE_NULL(Name,'value') for string type
Modify Operator does not exactly behave as described in the PX documentation. If you have a chance go through the Orchestrate documentation.
I am doing the same by HANDLE_NULL
This would definitely work.
Stat_Qanty = HANDLE_NULL(Stat_Qanty,0)
Stat_Qanty = HANDLE_NULL(Stat_Qanty,value) for a numeric type
Name = HANDLE_NULL(Name,'value') for string type
Thanks,
Kiran Kumar Reddy
Kiran Kumar Reddy
-
- Participant
- Posts: 5
- Joined: Wed Apr 20, 2005 6:29 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One of many errors in the manual. The functions that the Modify stage uses are similar but different from the functions that the Transformer stage uses; for example many of the Modify stage function names include underscores.
Maybe they'll become more consistent in a future release. Meanwhile you need to research and experiment to find what works (and share it here!).
Maybe they'll become more consistent in a future release. Meanwhile you need to research and experiment to find what works (and share it here!).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.