Yes i did Criag now..Let see...I will post the solution once they solve it....chulett wrote:Time to involve your official Support provider, it seems.
Logic Question
Moderators: chulett, rschirm, roy
guys,g_rkrish wrote:Yes i did Criag now..Let see...I will post the solution once they solve it....chulett wrote:Time to involve your official Support provider, it seems.
I contacted.. the support...
I solved that by....
We should not give thw like in the SQL rather we should give in the Transformer derivation for the refrence look up..
I.e.
when you do a look up on the string that you are going to match up for example
If you want to give in the like stament of sQL
LIKE '%?%'
I should be give in the Transformer Dervitaion part like this
'%':Regfrencestring:'%'
so you get what ever string from from the source that contains the string in reference...
thanks everybody for your support.Especially Ray...
Thanks,
RK
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Was your issue resolved?g_rkrish wrote:Ok here is what it is...ray.wurlod wrote:Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here. ...
We have a tableA. where we have strings like 1000 10001 1004..
There is another tableb which has real data....
The question is is ..
We need to find ...
1.What are the string in Table B that starts with strings in table A
2.What are the strings in Table B that contains strings in table A
3.What are the strings in Table B that is equal strings to table A
Pls let me know if you need more explanation on the problem.....
I was thinking of counting the length of data in table 1 (len(var1) and using the length to cut first part of data from table 2 and then match them. Cant think why it will not work...
I will not work..Beacuse your are matching the length rather than the string itself..suppose if i want to llok at start with 10 ..It may get the string start with 50 also..but i don't want that...Krazykoolrohit wrote:Was your issue resolved?g_rkrish wrote:Ok here is what it is...ray.wurlod wrote:Stop. Step back. Ignore DataStage for the moment. Write out (in English) a complete specification of what is supposed to happen, including one or two examples. Then post that here. ...
We have a tableA. where we have strings like 1000 10001 1004..
There is another tableb which has real data....
The question is is ..
We need to find ...
1.What are the string in Table B that starts with strings in table A
2.What are the strings in Table B that contains strings in table A
3.What are the strings in Table B that is equal strings to table A
Pls let me know if you need more explanation on the problem.....
I was thinking of counting the length of data in table 1 (len(var1) and using the length to cut first part of data from table 2 and then match them. Cant think why it will not work...
RK