tMap lookup issue

[Anonymous]

Tables : 

Category_tbl : categoryid(Auto Generated), CategoryName, CategoryCode

Product_tbl :  productid(Auto Generated),categoryid,productname

Category XLS : CategoryCode,CategoryName

Product XLS : Product Name,CategoryCode

My Process 

Read Catgegory XLS -> Write Category TBL -> Read Product XLS -> JOIN tables using tMap(CategoryCode)  -> Get categoryId from Lookup tbl -> Write Product with CategoryId(Foreign Key)

I Can't get the CategoryId from Lookup db connection(category tbl) component

[Anonymous]

Hi
Is it an inner join or left outer join on tMap? Can't get the categoryid even though the same CategoryCode exists in both tables? It might be an execution order issue, can you share a screenshot of the job?

Regards
Shong

[Anonymous · Accepted solution]

The categoryid is generated by database rather than coming from Category XLS, so you need to query the categoryid after you insert the category information into database, try to change the job to
Read Catgegory XLS -> Write Category TBL
|onsubjobok
Read Product XLS -> JOIN tables using tMap(CategoryCode) -> lookup (select categoryid, CategoryCode from lookup_table)

[Anonymous]

Hi shong, Thanks for your promptly response,

Write Category TBL is  tDBOutput(mySQL) component , Can't get onsubjobok event

[Anonymous]

Hi shong, Thanks for your support, It works now.