DSXchange

If you are expecting decimal values then your source should be either decimal or numberic with given scale, then while loading into file you can convert decimal to string and trim it and also your target should be a string like varchar.

Does your file contain only header and no data ?

You can use this syntax to get the first value in a line of a file. I am using 2 assuming first line is a column name.

You can use this in script.

Could you please elaborate your requirement.

If you want to go with UNIX then you can call the UNIX command or script from before job sub-routine in PX job using ExecSH or in command activity stage in a sequence job.

You can use FMT().
Do a search to find out how, based on your requirement.

If you want ':' between Firstname and LastName then use in column derivation

to_transf.NFNAME : to_transf.LNAME

Should be good.

Did you search the forum ?
What is the datatype ? Is the column stated nullable ? Try "If Isnull(col) then ' ' else col" instead of NullToValue.

Also move this post to parallel forum for better response.

Hi All, I am trying to join 2 files based on key1(int) and key2(varchar), its not finding a match when I use both as keys although I can manually see the file and finds a match. if I remove key2 its working on Key1 but key2 is required. I tried trimming both keys in both files but still no match. Bo...

Hi All, I have requirement where like KEY1,KEY2,COL3 1,A,200 1,A,200 1,A,200 1,A,300 I need to check if value of COL3 changes for same KEY1 and KEY2 then I need to reject the entire existence of KEY1 KEY2 value like in the example since 1,A has different value of COL3 therefore 1,A should be exclude...

I was working on it and found one solution, if I could add another column to my input file say SEQ such that it look like ID|VALUE|NUMBER|SEQ 100|AA1|1|1 100|AA1|2|1 100|AA1|3|1 100|AA1|10|2 100|AA1|11|2 100|AA1|12|2 100|BB1|23|1 100|BB1|24|1 100|BB1|25|1 100|BB1|50|2 100|BB1|51|2 100|BB1|52|2 100|B...

The break can be at any point, it should generate a new row with minimum and maximum value for every sequence stream. if any of the next value is greater than the next sequence value (like getting 8 after 5 followed by 9,10,11)) then there should be another row having the minimum as 8 and maximum as...

Hi All, I have requirement where for example I have sample data ID|VALUE|NUMBER 100|AA1|1 100|AA1|2 100|AA1|3 100|AA1|10 100|AA1|11 100|AA1|12 100|BB1|23 100|BB1|24 100|BB1|25 100|BB1|50 100|BB1|51 100|BB1|52 100|BB1|53 100|BB1|54 I need the output to be ID|VALUE|NUMBER1|NUMBER2 100|AA1|1|3 100|AA1|...

Afraid not, not until that "direction" is added in a future release as the pivot stage just does columns to rows. This needs a "stage variable concatenation" approach in a transformer to solve, probably with a dummy/trailer row to push out the last group when it hits EOD. You ar...

And can be achieved using PIVOT stage in parallel job.