DSXchange

I saw that, however, I didn't see where it says importing with multiple tabs. The documentation that I saw doesn't show, as well. The filepath is Link_Excel_EXTR, I go to the Link dropdown and it only shows that link, not multiple links [the documentation says Department and Employees somehow]. When...

Requirements from customer are to have the two tabs in same excel sheet. I tried a job doing a funnel but it won't work on the exporting columns

Hi, I have an excel sheet (2 tabs, different column names) that I want to simply push to an Amazon S3 bucket. Basically, unstructured data stage --> Amazon S3 My problem, potentially overseeing what I need, is that I want both tabs to be output and I cannot figure how to bring them in. Quickly on Ex...

Hi, I am bringing in 4 sequential files and performing a funnel. An example is shown below of one person with three rows: ID NAME Stat Code Stat Code Description 17137 TOM 05 RECEIVED 17138 TOM 04 ADD'L 17139 TOM 08 PENDING The files (combined) are 125 rows. I bring this into the transformer stage, ...

Hi again, I am using an FTP to shoot a file into the mainframe. However, when I run into the mainframe I am running into a problem where I can only transfer 80 characters out of my 3600 characters. I use my username/password for connection, FTP transfer mode and transfer ASCII with Overwrite as yes....

Thanks for responding. So let me give you the entirety of the job. I am taking an FTP to an external filter to get rid of Header/Trailer. Then I am using a transfomer to load two files and a DB2. For the file in question, I have a constraint based on my stage variables (I am creating error codes for...

Another brainbuster for you guys. I have a set of data that looks like this: AD43829T||||4,5 AF87571S||||4,5 CP06459X||||4,5 AD99586W||||4,5 CK71846A||||4,5 In the transformer, I want to add a header to this to make the output look like this: File partially processed|Total-10|Accepted-0|Rejected-10|...

I used the FTP stage to upload a file then I used the external filter stage to use the sed '1d;$d'.

It worked.

Thanks all

Thanks for the reply. My FTP stage (incoming) I have the URI and the needed options to view data. I then bring it to a transformer and I can use @INROWNUM for the first row but the LastRow() function isnt working.

I have a file with Header, Trailer as first and last records. I know about the sequential file sed "1d;\$d" aspect but I was wondering if there was a way to do this in the FTP stage.

Any help would be great.

Thanks,

Scott

So for somebody with no DB2 knowledge, I could use ISNUMERIC for the 1st character. Is there a ISALPHA and an ISALPHANUM function as well. I am referring to your 'regular expression' comment from earlier.

FranklinE,

How would I use the Num function to get rid of the 0? For ex: Num(Link[3500,1]) will see if the 1st char is 0-9. Is there a manipulation that will be able to make sure that 0 is not included?

Thanks

Im using this in the transformer using stage variables to create an error code. I figured it would be an If statement but I didnt know what the actual working of that would look like

Hi, I am trying to validate a sting that comes in from a file. I am taking a set of characters and I need to make sure that they meet a certain criteria. The character string will be in a fixed position in a file, 3500-3510 to be exact. First off, I need to make sure that there are no spaces and zer...

B and C need only to be populated if they have a value of 159 and 158, respectively. If B doesn't have 159, then it will not be included; same goes for C.