lookup value

Question

Hello,
In the mapping dataflow, I have a dataset which dynamically reads the required .csv file...
Inside the .csv file, there are several columns which indicate what kind of expression is to be applied to which column in which table
Below example shows sample data with ApplyExpr column which is the expression to be applied to that column...
note my expressions here are just tests...
for example:

TableName, columnName, ApplyExpr

TableName3 transferDate dateformat("dd/mmm/yyyy")
TableName3 travelName upper
TableName1 ticketNo >=10 to be 0
...

Question:
inside the mapping data flow, perhaps I can use a derived column to read the ApplyExpr value for the column...
How do I do this kind of lookup so that for example, looking at the data above, it says, for tableName3, for the columns transferDate apply the expr() as per ApplyEpr value

Hope you see what I mean.

Thank you

Answer 1

Thank you for the link to the video which I had watched previously.
This video is for a filter which applies to everything in a table.
I would like to have a derived column to apply expressions retrieved from a config file for each field in the table.
Any thoughts?

Thank you