Jump to content

Join two tables by using 3 columns and text function in freehand of the join

Abdelhak Khedhiri

Recommended Posts


I need to join two tables by using 2 columns (%1,%2)from the first one and 1 column (%3) from the second one.

Table 1: column1 contain data like PRJCDE and column 2 contain date like PRJCDE

Table 2 : column1 contain data like HOWPRJCDEPRJCDE

to joint de two tables i need to extractPRJCDEPRJCDE from column of table 2 (%3) and concatenate %1 and %2 of table 1 in order to set in freehand field of the join

Substring(HOWPRJCDEPRJCDE fom 4th position until the end to the string) = concatenation (%1 and %2).

I tried several text function Mid, lef, Right etc ... bu i continue to have error and the join can't be created.

Many thanks for your help and advice

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...