DSXchange

Bump, looking for a way so I can look through months using loop counter variable.

Hi ArndW, does this code allow for a loop counter variable to be added some where so I can say how many months to go back (1 being previous, 2 being 2 months etc..)? I'm subscribing to premium right now to view your answers

Would there not be an easier way using MONTH.FIRST. I only bring this up from other threads I'm reading. Also now that I'm thinking about it I would need to be able to specific how many months to go back. I may need to reload anywhere from 1 month to 12 months ago. I can use a loop counter variable ...

Ok thanks, any idea on how this can be done?

Right now that code is being used in a user variable stage in a sequence job. Will be using this solution in exact same stage.

Hi, I have the following function I use which gets me yesterday's date in format YYYYMMDD: Oconv(Date() - 1), "DYMD[4,2,2]" : @VM : "MCN") I would like to use something similar but, I would like it to return the previous month from today's Date. To be in the same format YYYYMMDD....

I am trying to complete the exact same task for JSON off a RESTful get. I ran into this same issue this week... and the V-Pivot is failing me.

However, in the log I see below message Peek_15,0: success:false errorMessage:CDIER0961E: The REST step is unable to invoke the REST service, cause=org.apache.http.conn.ConnectTimeoutException: Connect to welcome.coremetrics.com:443 timed out faultHttpStatusCode: faultHttpBody: httpVersion:NULL sta...

Is this warning telling me that it could not preserve it because of the re partition?

Hello, I'm am receiving the following warning when running a job. I am trying to clean it up any suggestions are helpful: Final_Clean_UP: When checking operator: Operator of type "APT_TransformOperatorImplV0S90_Metrics_Transform_Final_Clean_UP": will partition despite the preserve-partitio...

Thanks chullett. Actually some of my links have table naming convention in them so I thought it would be best to take those out. .

Correct.

Hi, Looking for help I believe this would fall under the category of a transformer last row in group scenario. But, would like some advice on how to approach - specific details are nice. I have data somewhat like this A, 1, z A, 3, z A, 4, z A, 7, z A, 10, z B, 4, z B, 5, z B, 6, z B, 10, z Required...

Thanks.

Hello, Looking to run two groom statements against tables. GROOM TABLE schema.sometable1 RECORDS ALL; GROOM TABLE schema.sometable2 RECORDS ALL; How can I run these commands? No data will be coming back so not sure if it is possible to use Netezza connector stage on its own or if I need some sort of...