Hi all i want to update the Field Value

[Anonymous]

Please find the below mentioned Query, I need to Update the Extension Field( which is entered in the inline Query) Based on the Employee ID ,

But when i run the Query it is Showing Synthetic Key, and output is not as expected Kindly do The needful,

EMP1:

LOAD *,

subfield([Full Name],' ',1) &' '&Subfield([Full Name],' ',2) as [Full Names]

//subfield([Full Name],' ',1)as Name

Resident EMP;

DROP Field [Full Name];

DROP Table EMP;

Inner Keep(EMP1)

[Company Details]:

LOAD

EmpID,

Company,

EmailID

FROM

(ooxml, embedded labels, table is Sheet1);

STORE EMP1 into (qvd);

Inner Keep(EMP1)

[EMP Details]:

LOAD *  Inline

[

EmpID,Extension

43,220

44,221

];

[Anil_Babu_Samineni]

Try to use NoConcatenate between EMP and EMP1?

[sunny_talwar]

May be use Inner Join instead of Inner keep?

[effinty2112]

Hello,

Does your EMP1 have fields named Company or EmailID? Maybe EMP1 has an employee e-mail address field called

EmailID which is being confused with the company e-mail address from Company Details. How many rows remain in your EMP1 table when the load is completed? If you give a screenshot of the Table Viewer that would help.

Regards

Andrew

[Anonymous]

After Applying Inner Join It is not Displaying Any Data.

[Anonymous]

Please find the Table Viewer Screenshot for your Perusal.