Flattening a file which has XML as well as sequential data

eostic · Post by **eostic** » Fri Oct 24, 2008 5:25 am

Parse it first....getting the xml into a single large varchar column, along with everything else....then go to an XMLInput Stage and do the XML work...."carry" the other columns on both the input link and the output link, with NOTHING in their Description property....the stage supports the concept of "passthru".......they'll just go thru unchanged.

Ernie

senthilt1 · Post by **senthilt1** » Fri Oct 24, 2008 6:11 am

Thank You.. will try that and get back to you..!!!

Regards,

Senthil

senthilt1 · Post by **senthilt1** » Fri Oct 24, 2008 7:22 am

It worked. But I am getting my first column as NULL. It is a NULLABLE column according to its definition but the input does hold a value for this column. I am using the same input, the one I posted.

Do I have make some adjustments in the settings to overcome this?

Thanks,

Rakesh Narayan.

chulett · Post by **chulett** » Fri Oct 24, 2008 7:24 am

Which "first column" - in the XML or outside of the XML?

senthilt1 · Post by **senthilt1** » Fri Oct 24, 2008 7:47 am

Outside the XML.

So in this case it will be '11111'. Instead of that it comes as NULL. It is a varchar field.

Thanks,

Senthil