[resolved] Is it possible to load multiple context variables in a single pass?
Is it possible to load multiple values from a Excel spreadsheet into multiple context variables in a single pass?
My goal is to have 3 context variables I pass data from a spreadsheet to and then use the 3 context variables in SQL against the Oracle database.
For example if I have a spreadsheet with three columns and three rows:
Col1|Col2|Col3
1|abc|123
2|def|456
3|ghi|789
My job looks like:
tFileInputExcel > tIterateToFlow > tContextLoad > tOracleInput
So far I am able to load the first context variable fine. Anyone know if how I can get the 2nd and 3rd context variable loaded with values?