How to use the peek function

[varma8998]

HI All,

I need help by using peek function how we will get the data from one table to another table

I have two tables

Table1:

Sl.No   Type     Method   Amount

1          XXX      AAA       1234

2          YYY     BBB         5678

3          ZZZ     CCC         91011 

4          AAA     DDD        121314

5          BBB     EEE         151617

Table2:

Sl.No Date

1        06/30/2019

2        09/30/2019

3        03/31/2019

I need the output in the data manager table in the below format is that possible

Output: in data manager table

Sl.No   Type     Method   Amount   Date

1          XXX      AAA       1234        06/30/2019

2          YYY     BBB         5678       06/30/2019

3          ZZZ     CCC         91011      06/30/2019

4          AAA     DDD        121314     06/30/2019

5          BBB     EEE         151617     06/30/2019

[dazerano]

Peek is not the function required for this. You could Join the tables but I would recommend using applymap() in this case:

MapDate:

Mapping

LOAD

   Sl.No ,

   Date

From Table1

LOAD

APPLYMAP('MapDate',Sl.No ,null())    AS Date

FROM Table2

[varma8998]

Hi,

I am getting error can u please help me with script

[dazerano]

What error are you getting? Can you post your script?