Hello
In a multi tenant app.
USERS table has a TENANT_ID column.
The app allows uploading an xlsx file containing product data to be loaded to PRODUCTS table.
This table has several columns to be loaded from the file + additional TENANT_ID column(Number data type).
I've created a data upload definition and the relevant mappings in the data profile. But i can't get the TENANT_ID column populated…
The current user's TENANT_ID is saved in an Application Item named also TENANT_ID. This item has the correct value when viewing the session state.
how can i get this application item copied?
I tried adding it as column in the data profile. Tried the SQL Expression option and the SQL single value with no success.