hi I am very new to talend. I want to have inner join between two tables with case insensitive condition. can I force the join between two tables on a column such that match returns true even if the data in two tables are in different case. Any help on this is very much appriciated.
janhess:
Thanks for the follow up.
I had tried that, but it doesnt seem to be sticking. Here's more info on my situation:
I have 1 excel file pulling in the records.
there are 3 columns with string based values that are values of a record in one of 3 tables of lists.
excel file:
id | make | drive | color
1 | Honda | AWD | red
2 | HonDa | | blue
3 | Dodge | Rwd | Black
4 | Dodge | 4x4 |
Tables:
Make:
1 | Honda
2 | DODGE
Drive:
1 | awd
2 | RWD
3 | 4X4
Color:
1 | Green
2 | RED
3 | BlacK
4 | BLUE
I need to pull in all records, no matter the case. This part seems to be working.
I am getting hung up I think when there is a missing attribute that is actually blank on the incoming rows such as :
id | make | drive | color
2 | HonDa | | blue (which should end up in the reciving table as: 2 | 1 | null | 4)
4 | Dodge | 4x4 | (which should end up in the reciving table as: 4 | 2 | 3 | null)
for these two records, for record #2, drive should just end up being 'null' when it gets inserted into the receiving table
and Color should be 'null' as well.
I added !Relational.ISNULL(incoming.drive) to the filter of initial tMap where I was doing the 'toLowerCase', but that didnt work. When I added it to the main tMap, I am getting an error there as well.
Is there a better/more accurate expression/location that I should be adding these?
thanks again for any / all help you can provide.
Hi I have some 100 tables in one database on one server and I want to copy all the tables along with the all the data to a different database on another server. How can I do this bulk migration. Any help is much appreciated
Hello,
I am trying to do the same as in the initial post, however I do not see the screenshots as indicated in the first (shong's) response. Would someone please repost images, or explain steps to get lookup column in lowercase in order to do the join?
Thanks in advance.
