Mapping issue

[buzzy996]

Hello quickers,

can you help how to map these two tables with out using joins.

Table 1:

Column 1: BillNum

-------

R847159 1

R839996/1

R637077 and R699751

R809861 / R816528

R848984 Item no: 8

R758771, R758772, R758773, and R789247

R578433 R545966 R574458 R568711

No.: R848984 Item no: 44

R848914

Column 2:Date

DR-07/05/2017-7949

DR-17/06/2017-7950

DR-19/06/2017-7951

DR-26/01/2017-7952

DR-22/06/2017-7953

DR-24/07/2017-7954

DR-21/06/2017-7923

DR-29/07/2017-7934

DR-19/07/2017-7934

Table 2:

Column 1: BillNum

--------

R847159

R839996

R699751

R816528

R848984

R758772

R574458

R848984

Column 2:EXDate

DR-07/05/2017-7949

DR-17/06/2017-7950

DR-19/06/2017-7951

DR-26/01/2017-7952

DR-22/06/2017-7953

DR-24/07/2017-7954

DR-21/06/2017-7923

DR-29/07/2017-7934

Question: need to map table 2_column 1 with table table 1_column 1 and expected output is table 2 Column 2.

Thanks

[Kushal_Chawda]

which number need to take from this string R758771, R758772, R758773, and R789247?

[buzzy996]

hi,second one "R758772",thank u

[antoniotiman]

Hi Shiva,

like this ?

[buzzy996]

hi,No.

expected result is table 2 with both the columns mentioned above.

thx

[antoniotiman]

Can You be more specific ? Below Final table from joined tables

[buzzy996]

Hi,This is expected output.

BillNum	EXDate
R847159	DR-07/05/2017-7949
R839996	DR-17/06/2017-7950
R699751	DR-19/06/2017-7951
R816528	DR-26/01/2017-7952
R848984	DR-22/06/2017-7953
R758772	DR-24/07/2017-7954
R574458	DR-21/06/2017-7923
R848984	DR-29/07/2017-7934

[Chanty4u]

Hi,

check this may be it will help

concatenate

[buzzy996]

hi,thanks for the above,but seems to be thr is no relation between these two cases.

[antoniotiman]

This ?