DSXchange

Thank you for all your inputs , I have tested (more testing in progess ) it by applying space (trailing) and looking for 'a ' and replacing it with ' ' . I will also test using loops and external filter as suggested Although , for looping , my logic greatly depends on the sequence of stage variables...

Thank you Kashyap, will try to implement that

Update - Somebody suggested (not finding the post anymore ) using a trim function with 'T' This helps because I can combine it with other logic to perhaps work it out However , Trim( string,"a","T") Trim with T option only seems to work for last words(in this case) so "abc d...

Hello everybody I have a string coming in its like abc def hsk nmps etc My requirement is to remove any letter 'a' from the words within the string if it appears as the last letter For example "abc def abca" should be come "abc def abc" "abc def' will not change "abc nk...

Thank you Shane "Shared Container output you have "surfaced" the columns A,C,D? " The shared container takes A,D as input (defined that way ) and outputs Columns 'A,C,D' Yeah B - remains hidden and I want it to be populated to output file but before that I want to select only col...

Hello i have a job Database->Transformer1->Shared Container-> Transformer2->file The requirement is to pull values of two columns A and B from DB to file Shared Container uses columns - A , D as input and A ,C , D as outputs -Enabled Job level RCP -Yes -Enabled RCP for shared Container - Yes -Enable...

That helps , Many thanks .

Marking the issue as resolved.

Oh ...You are right, My bad , I didn't check the SQL hard enough ... That solves the problem. However, How did you figure out that we need to concatenate the string with % signs ...I mean there seems to be no way to figure that out from the log . How do one get an idea ? Thanks again for all your in...

What is the exact sql you have in your sparse query? What is the exact error you are getting? What is the exact column name you are using in the lookup stage? * SELECT K.COMP_NM FROM COMP_NAME K WHERE K.COMP_NM '%'||ORCHESTRATE.COMP_NM||'%') * Lookup_41,0: The following SQL statement failed: SELECT...

i am using Oracle but the concatenation fails with the same error

I tried that earlier but saw the following error
"The connector could not find a column in the input schema to match parameter"

That's when I added the quote

Now , I see what your were saying , Yes the query works fine but only in external sql portal , not in database stage (Oracle) However , if I hard code with a value say 'A' to test the sql Instead of 'ORCHESTRATE.searched_string' select tab_col from table_T WHERE INSTR(Tab_Col,'A') >0 then I get requ...

Yeah , but as I mentioned , my requirement is to collect all the matching records (from database ) from each word within each string (input)

rkashyap wrote:You can also try to use 'instr' function instead of 'like'.

I think that will give you the position , i am looking for the matching string here
Thank you

Thanks for all your inputs Firstly I checked if my column name is exactly what I get in the transformer and then I took off the % sign , I get the exact same result , this tells me there is something wrong , but I just don't know what is it . Secondly , I did check the number of records with like st...