DSXchange

rschirm wrote:Try using Stage variables:

Variable1 = Period1:",":Period2:","Period3:",":Period4:",":...
Variable2 = Startdate-Enddate
Variable3 = field(Variable1,',',Variable2)

Then use Variable3 as the value to place in Period.

Brilliant, Thank you!!!

Thanks for your time. StartDate and EndDate are generating in middle of job using couple of lookups. Sadly, I cant write a query to accomplish it.

Hi All, Need your suggestions on the following scenario. Considering we have the following input schema as Input Schema: StartDate EndDate Period1 Period2 Period3 . . . Period30 Output Schema: StartDate EndDate Period Mapping: StartDate -> StartDate EndDate -> EndDate (EndDate - StartDate) We get th...

Hi I am trying to build an extract file with header and trailer records. Header comes from an audit table Header and trailer are almost same except that the trailer has no of records in the file (detail records) I have completed a sample job and its working fine except when there are zero records fo...