Hi
Source: XML FIle
Target :Sequential File
Processing Stage: Transformer.
I have date fields in the below format.
These fields are not getting populated into the sequential file.
The job is runnning fine.
Let me know,
do i need to use any date conversion here.
datatype is date from source and target.
ReqCancelDate="03/05/2008" ReqDeliveryDate="03/20/2008"
Date fields From XML to a sequential file......
Moderators: chulett, rschirm, roy
Date fields From XML to a sequential file......
Thanks,
Pavan
Pavan
If it's that simple a job, check your xpath.... (Description property on the noted columns in the output link of your XMLInput Stage).....
One guess is that the columns simply aren't in the link... (could be that they weren't in the referenced XML instance doc that you used for meta data import).
Also could be that there is a spelling error. hard to tell without seeing it here...but you should have something like a column called ReqDeliveryDate with Description propety of:
/<your higher level element(s)/<immediate higher element>/@ReqDeliveryDate
Make the datatype varchar.
Ernie
One guess is that the columns simply aren't in the link... (could be that they weren't in the referenced XML instance doc that you used for meta data import).
Also could be that there is a spelling error. hard to tell without seeing it here...but you should have something like a column called ReqDeliveryDate with Description propety of:
/<your higher level element(s)/<immediate higher element>/@ReqDeliveryDate
Make the datatype varchar.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
eostic wrote:If it's that simple a job, check your xpath.... (Description property on the noted columns in the output link of your XMLInput Stage).....
One guess is that the columns simply aren't in the link... (could be that they weren't in the referenced XML instance doc that you used for meta data import).
Also could be that there is a spelling error. hard to tell without seeing it here...but you should have something like a column called ReqDeliveryDate with Description propety of:
/<your higher level element(s)/<immediate higher element>/@ReqDeliveryDate
Make the datatype varchar.
Ernie
It worked..........now.
I have the datatype for the date fields in Transformer as Varchar.
Thanks a lot....
Thanks,
Pavan
Pavan