Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using MySql Bulk Exec with column defaults

Hi
I plan to use the Bulk Exec task for MySql to load a data file into my staging tables for preprocessing. The stage table has a column which is company_connector_id that identifies the source of the data(this is an internal identifier). This column is obviously not available in the client data file coming in.
If i was to load this data file through the MySql command i would use the command

load data local infile 'filepath/filename' into table stg fields terminated by '|' lines terminated by '\r\n' 
(column1, column2, column3....)
set company_connector_id = 1234

The value of the company connector id would get set. 
How do i do this when i am using the tMySqlBulkExec task? I can pass it through a context but how can i set it through the task? 

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Read the client data file and rewrite the file to add this column before loading it. 
Best regards
Shong