# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## Fill In Existing Field

Looking for an efficient way to solve this.

Current Data:

ID, Letter, Test

01, A, 1

02, B, N/A

03, C, 2

04, D, 3

05, E, N/A

New List:

Letter, Test

B, 5

B, 6

E, 8

E, 9

OUTCOME:

01, A, 1

02, B, 5

02, B, 6

03, C, 2

04, D, 3

05, E, 8

05, E, 9

Hope this helps.

Tags (1)
4 Replies
Contributor III

## Re: Fill In Existing Field

Try this:

temp_current:

load * inline [

ID, Letter, Test

01, A, 1

02, B, N/A

03, C, 2

04, D, 3

05, E, N/A

];

Left Join (temp_current)

New:

load * inline [

Letter, Test2

B, 5

B, 6

E, 8

E, 9

];

current:

ID,

Letter,

If(Test<>'N/A',Test,Test2) as Test

Resident temp_current;

Drop Table temp_current;

Honored Contributor II

## Re: Fill In Existing Field

Hi,

Try like this.

TestMap:

Mapping Load * Inline [

Letter, Test

B, 5

B, 6

E, 8

E, 9

];

Test:

load *,ApplyMap('TestMap',Letter,Test) as TestRevised;

LOAD * INLINE [

ID,Letter, Test

01, A, 1

02, B, N/A

03, C, 2

04, D, 3

05, E, N/A

];

Drop Field Test from Test;

RENAME Field TestRevised to Test;

Thanks,Deva

MVP

## Re: Fill In Existing Field

Hi

Try like this

Current_Data:

[

ID, Letter, Test

01, A, 1

02, B, N/A

03, C, 2

04, D, 3

05, E, N/A

];

New_List:

Join

LOAD Letter, Test as T1 Inline

[

Letter, Test

B, 5

B, 6

E, 8

E, 9

];

Final:

LOAD Letter, If(Test = 'N/A', T1, Test) as Test, ID Resident Current_Data;

DROP Table Current_Data;

New Contributor III

## Re: Fill In Existing Field

you can try this

CurrentData:

load * Inline [

ID, Letter, Test

01, A, 1

02, B, N/A

03, C, 2

04, D, 3

05, E, N/A ] Where Test='N/A';

left Join

Tmp_NewList:

LOAD Letter, Test as Test2;

LOAD * Inline [

Letter, Test

B, 5

B, 6

E, 8

E, 9 ];

DROP Field Test;

RENAME Field Test2 to Test;

Concatenate(CurrentData)

load * Inline [

ID, Letter, Test

01, A, 1

02, B, N/A

03, C, 2

04, D, 3

05, E, N/A ] Where Test<>'N/A';

resgards,

hemesh