DSXchange

ray.wurlod wrote:Why not just convert the original string using a format string of "%yy%mm%dd" (with no delimiters, just like the data)?

Ray,
I am sorry , I don't think I understood your question (or suggestion here) ? Can you please elaborate?

The fundamental problem here is the fact that dates have no format. Got it . Yes , This is just an external string representation of dates. So StringToDate pretty much converts the string (of given format) into a Date . So when I tested this by using StringToDate(linkname.DateString,"%yy%mm%dd...

Hello All, Perhaps this question is very simple but at this point I do not know a way to do it. I have a string in the format yymmdd and I want to convert it to date format of mm-dd-yy . I am achieving this by first breaking the string into the required format of mm-dd-yy by using substring and conc...

Sure I tried to search on key words/phase "parameter value reading from file" "table names from file" What I am not sure is does it need a job sequencer to perform this kind of activity to start with or is there a way to simply point the parameter to a file (I don t see this opti...

Update I could not find the solution on this scenario post searching .

I am sorry - I meant I that I do not know "What phrase on which I need to search for this kind of scenario "


However I will try searching on "reading table names from file"

Hello All I am trying to load a set of tables from one database to another (simple straight load) , However at this point I am using RCP and manually providing table names (as parameter value) for each of the tables being loaded (one at a time) I wanted to see if there is a way to automate this proc...

Sure I will try that and post an update - At present I will mark this topic as resolved at least as a work around.

Thank you

I don't see anything wrong with the derivation you posted, it should work exactly as you say you need it to. And if you are careful with spreading the derivation to the other columns and ensure you're using the correct input in the check to match the output column I don't see any reason why you wou...

prasannakumarkk wrote:Am not sure whether you checked this environment variable APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING and replied.

Sorry , Yes I think i did not answer this one - This is currently set to False.

- In my code if I use a space instead of Null it works .


Thanks again

-Craig, Thanks for the clean up and I will try to be more careful with column delimiters next time. To answer your question on the code - Yes this is precisely what I am trying to do. Each row of the output should have only one new column value populated (which is corresponding to the flag and code ...

stage variables dont handle null values properly in px transformer. So give it as blank. When it works, then in the column expression you can use SetNull() for blank. Yes I tried this one before posting the question suspecting the same but initialized with 0 . This still did not work . However as y...

I am in 8.5 version now , however , i have started testing using spaces instead of null and it seems to be working. So I think even if the field is null, assigning a stage variable to null will not work in my above logic. I am still not convinced as why Setting this to Null will NOT work but setting...

Thank you Prasanna
But are we not substituting Null with a blank in here , for me Null or blank doesn't matter , its just that I am getting a value for new output columns based on previous records on top of my required code field value.

Do I make sense here ?

Update - I retested my code with real data but say 20 records but first sorting the data with code as key. So here is what it looks like its going wrong if the first row has a code of 1 with Flag as 'M' then all the columns of the output are populating correctly , which means the OUTPUT columns row_...