DSXchange

The above logic doesn't work out. Basically, I want logic to subtract N weekdays from a given date.While subtracting,we will not consider Saturdays and Sundays. This will give you the no.of weekends in that 23 days (YearweekFromDate(DateFromDaysSince(23, StringToDate('2011-05-09')))-YearweekFromDat...

Hi IF the input column contains two words i have to take first word in to one variable and second in to another and again in the first word i have to check for the hyphen(-) and if it is there i have to take the part before the (-) in one variable and part after the (-) in another variable. thats w...

Can you brief the logic only with example?

word1 : if StageVar1=0 Then to_processing.pri_emp_add1 Else to_processing.pri_emp_add1[1, StageVar1-1]

firstpart : if StageVar=0 then Word1 else Word1[1, StageVar-1]


-Paul

saraswati wrote:Please let me know a logic to find out the number of weekends ( Saturdays\Sundays) between two dates.

Use the following parallel function. You have to handle all the special cases

(YearweekFromDate(StringToDate('2011-05-31'))-YearweekFromDate(StringToDate('2011-05-09')))*2

-Paul

Hi, It is altogether a different requirement , This is for converting single row into multiple rows Split these records in the transformer with out any constraint then pivot these links such as Link1: COL_A1 COL_ID COL_A2 COL_CODE COL_A3---------->pivot CoL_A(COL_A1,CoL_A2) COL_ID Col_B COL_CODE Col...

Hello Create 3 stage variables (no need of split and collect the data ) 1)if not(isnull(ColumnA1)) Then ColumnA1 Else if not(isnull(ColumnA2)) Then ColumnA2 Else ColumnA3 Else 0= StgA 2)if not(isnull(ColumnB1)) Then ColumnB1 Else if not(isnull(ColumnB2)) Then ColumnB2 Else ColumnB3 Else 0 = StgB 2)i...

Read as a single varchar column(with out column length) correct each line in a transformer ,use column import to split the data into actual meta data

There might be better solution than this ,Try this and let me know Job 1 Create a job to split the actual file based on the columnB(Ref_No) ,one has all the '0000'records with sequncenumber and other has sorted(desc) not like '0000' records surrogatekeygen---->seqfileMater.txt(SEQ,ColumnA,ColumnB) C...

Hi,
Read the file as a single varchar column(without data length) , remove the blank line based on the length.Use column export to split the records into multiple columns

-Paul

Sort the input data based on the column B and enable the key change column Use filter to spilt the input data based on change value '1' or '0' Left Join the '0' stream with '1' stream based on the column B and retrieve the Column A from the '1' Stream . Filter the data based on Stream0.ColumnA- Stre...