Load table with missing value

[User12321]

Hi,

Table A has fields Col1 and Col2 that is pulled using a left keep to Table B. The common field between the 2 tables is Col1.

There are some Col1 that are present in Table B but missing in Table A. I want all Col1 in Table B to have a row in Table A. Those that do not have a row will have Col2 as NA. 

Can someone help me please. Thank you.

[anat · Accepted solution]

can u try some what like below:

dim:
LOAD * Inline [
id,dept
1,asd
];

Fact:
LOAD id,'n/a' as dept;
LOAD * Inline [
id,name,sal
1,as,100
2,we,200
] Where not Exists(id,id);

Right Keep(dim)
Fact1:
LOAD * Inline [
id,name,sal
1,as,100
2,we,200

];