DSXchange

Ernie, I have a small doubt, I need to pass column/field name along with column value, am I right? Before Pivot stage can I use transformer to pass the column/field name by hard coding column/field name. If it is so then I got the output as you advised me in previous post. Please advise me. Thank you,

Thanks Ernie, I am able to drag columns out from pivot stage. So in my case each row is getting split in to 15 rows (4 date columns so each date has day, month and year so 4*3=12 and then title, funder, amount. Total 12+3=15). Could you please advise me how to proceed further after pivot stage outpu...

I also tried by making some/all columns as keys even though I am getting same output.

Thank you,

Thanks Ernie, I searched on DSXchange/Google and tried in the following way. /import-record[@type-id=1]/native/field[@name="application-date"]/date/day /import-record[@type-id=1]/native/field[@name="application-date"]/date/month /import-record[@type-id=1]/native/field[@name="...

Hi, I need to generate following XML format. Could anyone advise me on this? <import-record type-id="1" xmlns="http://www.simple.com/publications/api"> <native> <field name="application-date"> <date> <day>element.getStartDate().substring(3,5) </day> <month>element.getSt...

Thanks Ernie,
To debug I was trying with fewer columns. So I added all the required 12 columns including "NUM" and definitions to all columns with ending /text(), still it is returning in the old fashion and I tried to change different settings and all but no use.

Thank you,

Thanks Ernie,
I added /text() to all 3 columns (descriptions) and I am using aggregate on the detail tab, I made num as key and not running any nodes I am running under sequential mode but still getting the output in the old way. Please suggest me.

Thank you,

I am using following expression to create XML

/import-users-request/users/user/num
/import-users-request/users/user/title
/import-users-request/users/user/initials

Thank you,

I added an extra field "Num" (using surrogate key generator) to that then it started returning output like this. Input: Num -- Title -- Initials 61 -- Student Assistant -- F 62 -- Student Assistant -- F 63 -- Student Assistant -- F Output: -<users> -<user> <num> 61 </num> <num> 62 </num> <...

Hi, I am working on java integration and for that I need to pass XML data. I am using XML output to get XML format from oracle table data. If I am passing duplicate rows I am getting only one row (first tag is repeating). Please take a look at below output format. I need 3 rows separately. Please ad...

Thanks Ernie

Hi,
Could anyone please suggest me how to generate only odd numbers as (1,3,5,....) surrogate keys ?

Thank you,

Ernie,
Server job doesn't support java integration stage. Any suggestions please?

Thank you,

Thanks Ernie,
I was using parallelism all the time but for this particular job I need to consider the output of previous processed rows to process remaining rows thats why I run in to this issue. I will check process row buffering settings at project level also. Thanks for your input.

Hi, I need to process one row at a time. I mean my job needs to touch 2nd row after 1st row got processed completely. I am pulling data from oracle and doing some transformations and then passing to java integration stage. So I need to process one row at a time because java integration stage writes ...