It needs to use the data from three tables. I have link between those three tables. but when I am selecting columns it is getting blank values for one table columns could anyone let me know how to solve this please.
Organisation:
LOAD companyId as EmployeeId
FROM qvd;
CreditorClaims:
LOAD EmployeeId,
FROM qvd;
Employee:
LOAD '1' as FLAG, EMPLOYEEID as EmployeeId, FROM qvd;