DSXchange

Thank you so much.

I will try to get help...

Yes, I went through the document. It describes how to view the generated stylesheet in Job log view. I couldnt find where the generated file is placed and how it can be accessed. Xpath expressions: /ENBELOPE-HEADER/GROUP_NAME/text() /ENBELOPE-HEADER/Source/text() /ENBELOPE-HEADER/H_DATE/text() /ENBE...

Thanks for your reply Designed the job like this to verify whether able to extract all the data from xml. Folder Stage ------> XML Input --------> Sequential Stage I set the TagName as key field as it is a repeating element and extracted the data. Its extracting only the first value of A, B & C ...

Can anyone help me in resolving this issue?

Thanks for your reply. I imported the metadata from XML file. Header text from the XML should be loaded into parent table and body text should be loaded into a child table. [quote]<ENBELOPE> <ENBELOPE-HEADER> <GROUP_NAME>DETAALLOAD</GROUP_NAME> <Source>GOCRS1</Source> <H_DATE>2007-07-04</H_DATE> </E...

Hi Friends, I am new to Datastage so pls help me in resolving this issue. Input XML: <TAGS TAG_NAME="KK_ABC"> <A>1</A> <B>703</B> <C>G</C> <A>2</A> <B>701</B> <C>G</C> <A>3</A> <B>698</B> </TAGS> Tags A, B and C are repeated multiple times in the input XML and i have to extract all these v...

It works for coverting first column into row but couldnt covert the other columns. Is it possible to achieve it in any other way?

Thank you for the reply.
I am also trying in the same way. I extracted the headers seperately but could not achieve the output. Can you pls explain in detail?

Can anyone think of a solution to this problem? I have a CSV file with header in first 2 rows and they will remain constant. Only the value in the 3 row will change. I have to load this data into a table. Input CSV file: Prod1,,Prod2,,Prod3 Loc1,Loc2,Loc1,Loc2,Loc3,Loc4 1,2,3,4,5,6 Output: Prod1,Loc...