DSXchange

How can I make the file coming in read exactly that way throughout the entire job? I have the file and I am bringing it to a transformer and then to another transformer and, lastly, the dataset. If input file reads PROV, ADDRESS, ASSOC, ENTY, PROV, how can I keep the exact formation of the file?

I used Same partition in the first transformer, hooked that up to a dataset and the columns are all varied. Is there a better way for this?

I input this sv and named it "PID". I set the derivation as above. I drag that derivation into the PID column that is created and the output is weird. The PIDs go well with the PROV_TB, they match the 8 characters. And then the rest of the rows do not. The column is a mess. If PROV_TB is 4...

When you say stash it on the PROV_TB record... How do i go about doing this? To give a little more insight, I have a job with the text file, a column import, 2 transformers and the final dataset (which I will use for the next job). In the column import, I am taking out the TABLENAME & CLOB, and ...

My company still hasn't received the Premium membership as of yet. All I can see is up to "...Have You tried, have an..."

Different conversion... I want to do a copy and paste kind of thing. I want to copy the PROV_TB ID (44224448) and paste it into the rows under it

Hi, I want to set a certain character set to rows. To try and explain... TABLENAME CLOB PROV_TB A44224448 ADDRESS A44224448 ASSOC A0000000 TAXES A0000000 ENTY A0000123 PROV_TB A6541235 So I have 2 columns named TABLENAME and CLOB and the first row is PROV_TB and it has an ID of 44224448. The rows fr...

I clicked the ellipsis and there is no list. It just says "All activities on the chosen Activities output". So if you do not see the need for the user variable stage, and variables in there, what do you recommend? I have the Command execute stage with the UNIX filepath in it. From there ar...

Yes, for the parameter, I cannot create it within the stages themselves. I made variables in the User variable Activity stage for each exit code (0-7). I do not know how to go about putting parameters within the stages so that they populate in the job activity stage ( in the job tab). How/what are t...

I inserted a filepath to the Execute Comm. I need two outputs as follows : Job Activity 1 : UNIX return code (good or bad) is going here and populating that return code into a transformer into the Job itself. The job has a column named 'PROCESS_CODE" and i want to populate it in the derivation ...

Thanks for the response Ray, I tried buying a premium membership but site declined my card. I won't bother asking/replying until I get my membership

Hi,

I have a text file and there is a string 'PROVIDER20151120'. I need to extract that 20151120 and convert it into 2015-11-20. I used StringToDate(NYMMIS_TB_EXTR.CLOB [9,8], '%yyyy%mm%dd') to no avail. Any help would be great. Thanks

Can you explain a little bit more. I am new to this tool and it is my first time programming. The UNIX script was created for me and I input it into a sequence job. In the job activity 1, I have the script text file filepath and the main text file it is going to attack. In job activity 2, I set the ...

Hi! I have a question regarding the codes that the UNIX script will push out. I input an expression ( "Field(Execute_Command_0.$CommandOutput,@FM,1) >0") into the command execute stage (of sequence job). So no for the hard part... Is there a way to link that UNIX code (mine is 1-7) into th...

The CLOB has 700 characters in it. The info I put out there are the first characters in the column itself. I need to extract those in my transformer but I am having a time with it.