DSXchange

Hello All, I need some help in fixing my routine. I am not getting the expected results. In simple english the result I want is : If Result is @TRUE and (CurrDate = PrevDate or MinCurrDate = MaxEndDt) and StCode in (20,29) then I)If EntryDt is between start and enddate then count =1 2)If MaxEndDt = ...

Hello All,

Which is the good idea to check for nulls if the source is a seqfile. Either '' or @NULL if the 'Defalut null string' text filed is blank on the format tab.

thanks

Hi All, I need help in understanding the boolean expression. The expressions below are in a routine If previous.col = current.col then ResultCol = @TRUE else ResultCol = @FALSE When I have the condition like Ex: If Not(ResultCol) then 'xxxx' else 'yyy' When we use the Not() with boolean does it mean...

Kenneth, thanks for the help.

Sorry for the inconvinence. Here is the example Names of the 10 columns SR_ID,PAT_ID,TYP_CD,CNT_NBR,MB_NBR, EFF_DT,PR_CD,AGE, GRP_NBR,DIV_NBR,PR_CODE If first six columns have the same values with different PR_CODE then based on the rules delete the complete records from the list. If PR_CODE = 4 the...

Thanks for the quick reply. As I am new to this can you please briefly explain what you exactly mean by highest importance code encountered You will need to do two passes thru the source data. The first pass will establish the highest importance code encountered for a group. You will want to write t...

Hello All, My source table have 10 columns and I have to add a new column count in my trasformation to load into the target table which have 11 columns. I need some idea in implementing the logic below. I have to compare the first 5 columns with the previous rows and if they are equal loop through t...

Which is the best way to implement the below conditions in the routine. If PROGRM = 999 AND Not (CODE[1,3] >= 551 and CODE[1,3] <= 562) AND Not (CODE[1,3] >= 890 and CODE[1,3] <= 889 AND ((CODE2[1,3] >= 581 AND CODE2[1,3] <= 591 ) OR ( CODE2[1,3] >= 641 AND CODE2[1,3] <= 645 ) OR ( CODE3[1,3] >= 581...

Hi! All, If you have 3 different jobs in one window which one will run first. Does all three jobs run parallel or will they run in the order they are. For example: In one window one job creates a flat file with the header row and second job will append the detail to the headerfile and third will app...

Thanks for the replies. Ray, can you please explain in detail as I am new to the basic routines how am I going to add the header record with hardcoded value 'H' and the creation date to the first line of my target flat file and leave the rest of the columns empty. The details should fill with 50 col...

Hi All, I am extracting aprroximately 50 columns from a database to a fixed width flat file. According to my requirement I have to add a header and a trailer record. The header record contains 2 columns(type and creation date) and this should be the first row in the file. The trailer record contain ...

Thanks Craig,

Do you think is there any easy way to handle all the Nulls??

Hi All, We have 50 columns in our source and we don't want to allow nulls in any of the columns. Which will be the the easiest way to do it. Writing a constrait using Not(Isnull(InputColumn)) on every column will be a big pain I think. One more simple question for you guys but not for me, how do we ...

Thanks for the reply. Still I am not able to split the column through this stage I don't know whats wrong am I doing. I have the job design like this seq-->trn-->rowSplitter-->Seq | V hash Input Seq is a .CSV file with input columns ( c1 char(12), c2 char(12), c3 char(4)). How can I split the column...

Hi All, How does the row splitter stage work and what for is it used. I thought it will split one row into multiple columns but not able to split the rows I guess I am doing something wrong. In the stage input it will ask for the name of the row which we want to split and in the output columns some ...