Hi
I am loading the xml file to sequential file using the server jobs.
my job design is like: folder stage--xml input---transformer-sequential file
my source is like: <customer value="123">123</customer>
<custid value="234">234</custid>
but after loading this file i am getting only data of 123 and 234 but not with the columns.
could you please guide me how solve this problem. and i want to create more than one record for column . how to do that please help me.
thanks in advance
sunitha.
xml file loading
Moderators: chulett, rschirm, roy
Not sure how you imported your metadata, but ultimately, on the output link of your xmlInput Link, scroll to the right and look at your column Desscriptions. The answer for something like this is usually in there. You will want to see something like (for each column in the grid):
Customer /.../.../Customer/text()
CustomerValue /.../.../Customer/@value
Where "Customer" retrieves what is inside the >123< (this is the value of the xml "element") and
"CustomerValue" retrieves what is inside the ="123" (this is the value of the xml "attribute").
Ernie
Customer /.../.../Customer/text()
CustomerValue /.../.../Customer/@value
Where "Customer" retrieves what is inside the >123< (this is the value of the xml "element") and
"CustomerValue" retrieves what is inside the ="123" (this is the value of the xml "attribute").
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>