DSXchange

....... or a lookup into a calendar / date table.

Remember having this issue under SP2 or not being an admin.

Remember having this issue under SP2 or not being an admin.

Five keys.

Id
Eff_Date_From
Eff_Date_To
Term_Date_From
Term_Date_To

Have a 'pre-job' script to copies a template SQL and convert all parameters with corresponding incoming values.

You can modify multiple columns in one go - if they have similar / identical derivations.

Try with a space before your backslashes.

Create 5 columns from the reference as keys (1 for key, 2 each for the dates).

Make them continous in a single line.

Aren't there name unique ?

==== Input: ==== colX colY 1 Bill,Brain,Greagory 2 Sam, Bopel 3 4 Toby Here the max occurance = 3 (for row 1). Step1: So generate 3 rows from rowgen. ===== rowgen: ===== colDummy colIndex 1 1 1 2 1 3 Step2: Add dummy column to input colDummy colX colY 1 1 Bill,Brain,Greagory 1 2 Sam, Bopel 1 3 1 4 T...

What is the start position you provided? It must be 8.

Surprising that it left the top 5 lines. Did you give the header lines?

What does the value for parameters say in Director ?

Also if you want to a thorough solution, go for an unix command or vector or build op.

Row generator will produce 2 columns which are 1.) a dummy column (say constant 1) 2.) sequence from 1 to n (n = max possible list of values in the column you wish to split) Add the same dummy column to your input row. Join them, use the sequence column to field() and add necessary constraints. You ...