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

[buzzy996]

thank u very much,seems to be this will fit as per the above scenario but need to check how will fit in my overall solution,will check and let u know.

is't possible to use mapping functions instead of join here and i need to maintain my table 1 data as well.

[antoniotiman]

Another approach

MapTable:
Mapping
LOAD A,'{<'&A&'>}' as B Inline [
A
R847159
R839996
R699751
R816528
R848984
R758772
R574458
R848984];

Table1:
LOAD *,TextBetween(MapSubString('MapTable',BillNum),'{<','>}') as BillNum1 Inline [
BillNum|Date
R847159 1|DR-07/05/2017-7949
R839996/1|DR-17/06/2017-7950
R637077 and R699751|DR-19/06/2017-7951
R809861 / R816528|DR-26/01/2017-7952
R848984 Item no: 8|DR-22/06/2017-7953
R758771, R758772, R758773, and R789247|DR-24/07/2017-7954
R578433 R545966 R574458 R568711|DR-21/06/2017-7923
No.: R848984 Item no: 44|DR-29/07/2017-7934
R848914|DR-19/07/2017-7934
](delimiter is '|')
Where Len(TextBetween(MapSubString('MapTable',BillNum),'{<','>}')) > 0;