Joining tables but after field manipulations

[Rsaiq]

Hi All,

I have 2 table as sales and quote like below,need to do left join after field manipulations in qlikview

Sales:

Id Amount

1 100

2 200

3 300

4 400

5 500

G6 600

YY7 700

UUU8 800

Z9 900

EEEEEE10 1000

UUUU11 1100

12 1200

13 1300

N14 1400

Quote:

Id Amount New

1 200

2 300

3 400

4 500

5 600

6 700

7 800

8 900

9 1000

10 1100

11 1200

12 1300

13 1400

15 1500

I need to add characters same as id of sales into id of quote first and then need to do left join and result should like below

Id Amount Amount New

1 100 200

2 200 300

3 300 400

4 400 500

5 500 600

G6 600 700

YY7 700 800

UUU8 800 900

Z9 900 1000

EEEEEE10 1000 1100

UUUU11 1100 1200

12 1200 1300

13 1300 1400

N14 1400 -

Please help me to get this resolve.

Thanks in advance

[Rsaiq]

Thanks @vinieme12 , @sidhiq91 , @Mark_Winter , @QFabian your valuable comments it helped me a lot.😀

[Rsaiq]

Thanks @vinieme12 , @sidhiq91 , @Mark_Winter , @QFabian your valuable comments it helped me a lot.😀