DSXchange

Hi Reddy,

We had a similar problem when we were trying to load data to SAP for Norwegian Characters.

Using NLS UTF-8 had resolved it.

Hey I have written a job control that can easily do this task. OPENSEQ "/home/dsadm/Input.txt" TO INPUT1 THEN Call DSLogInfo("File Input.txt Opened Successfully.","Generating a Different Sequence") END ELSE ErrorCode = 1 Call DSLogInfo("Error in Openening Input.txt...

Hi Ram, If you use Sort -u then only those records will be considered duplicates in which values for all the columns are duplicated. You can check for the details of this command by doing man sort For Example if your input file looks like this 1,2,3,4 1,1,1,1 4,4,4,4 1,1,1,1 then a sort -u InputFile...

Hi,

You can get your date in this format YYYYMMDD and then pass the data through an Aggregator to find the max date.

Hi,

In the LookUp set the property If Not Found - Continue

Then in the transformer you can check for the value of column A in the derivation as

If IsNull(lnkLookUp.ColumnA) Then " " Else lnkLookUp.ColumnA

Hope this helps.

Nice way of earning points without any strong inputs.

Hi, There are many ways duplicates can be removed, 1)You can pass the rows through a Aggregator and Group on the keys 2)You can read and write a the same hash file and check for constraints IsNull(Key) in the transformer --------------------Hash File Input File -------Transformer-----------Output Fi...

Hi, Ya indeed you do not need to sort the data the below logic will work provided the input records arrive in the same order as specified in the question. Also, if that is not the case then sorting will have to be done and a relation between X and Y will have to be established as mentioned earlier b...

Hi, -k keydef it defines a restricted sort key The format of this defination is field_start[type][,field_end[type]] which defines a key begining at field_start and end at field_start.The characters at field_start and field_end are included in the key field. You can use this option when you have an a...

Hi,

Why are you not using the SORT STAGE?

Hi Ravi, If I have understood your problem correctly then, You have used a Complete Set as the Join Type so If the key does not exist in the any of the input files you will get null values for that key For Example, You have First file Input "Code","Name","Color" "1...

Hi, If I have understood your requirement correctly You can define a stage variable say StgCheckDup with derivation, if Left(DSLink3.Value,1)='Y' and DSLink3.Sequence<>"001" then if RowProcCompareWithPreviousValue(DSLink3.Sequence) then 1 else 0 else 0 In the output column derivation you c...

How do I further use the pivot function I am unable to follow. Could you please help on this Hi Varsha, You can use the Convert function to convert all the "&" to "," So after conversion your data will look as follows 1,A=B,C=D,E=F,G=H 2,L=M,G=H Then you can use the pivot to...

You can also try the COMPARE function

$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF

Add this to the begining of the code and try compiling.