DSXchange

srinivas.nettalam

Haven't you tried writing the xpath description for that field?It should work if other columns are getting parsed correctly.

srinivas.nettalam

...I have created a field FILE_NAME (same as Input column name) , it doesn't have any derivation (1st field)....

It doesn't have any derivation means you are passing '' or simply mapping the input file_name column?

srinivas.nettalam

Which version of datastage are you working on?

srinivas.nettalam

Searching in this forum for "vertical pivot" will give you solution.

srinivas.nettalam

Would you post the sample value of the filename you are getting from ESS and the derivation in the transformer??

srinivas.nettalam

Hi Ray,
Don't we need compiler on an environment if we are importing the executables on that environment?

srinivas.nettalam

You can search for Convert or Double Convert to get an idea of resolving similar kind of issues.However I am not aware of the part of your question regarding the non-English characters occupying more than 1 byte.

srinivas.nettalam

My mistake I mean COUNT on the rows only,but not on a field.

srinivas.nettalam

times29 wrote: any idea what can i do to make it unique

To get unique sequence number across, the formula is

Code: Select all

[@PARTITIONNUM + (@INROWNUM-1)*@NUMPARTITIONS]+1

srinivas.nettalam

It works for even COUNT but am not sure of SUM.

srinivas.nettalam

Since the job runs in parallel @INROWNUM can have same rownumber on each node.Probably this is the reason.Not sure.

srinivas.nettalam

Apparently from ESS stage you are counting the '/' and taking out filename part only and passing to the XML input stage. But the usual way is to use 'ls /path/filename.xml' and pass the absolute path of the filename to the XML input stage.

srinivas.nettalam

qutesanju wrote:thanks I used sort stage with key change column and redirecting rows with keychange as 0 to file.

this way i was able to see duplicate records in separate file

Were you trying to do the lookup with the same data?

srinivas.nettalam

Hi Ernie,
Can we use a hash file(server job) instead of a sequential file in the target for this scenario to make the job run continuously?

srinivas.nettalam

You can count the number of '\' and take the text after the last '\' using string functions.

Code: Select all

For eg : Field(FileNameColumn,'\',Count(FileNameColumn,'\')+1)

DSXchange

Search found 135 matches

Re: handling non-english characters that is part of a string

Re: Sum, Count on varchar in Aggregator

Re: Sum, Count on varchar in Aggregator

Re: Reading only file name in Datastage Windows