I have one table which fields name should be change as per the MASTER_Temp TABLE
LOAD * Inline [
LOAD * INLINE [
But in our scenario we need to create some different level which a calculated fields i.e. Region Level_1, Region Level 2 and its name should be change dynamically
Even though I have created the logic for the same,But I just want to know ,Is there is any other better method i.e. by loop or something else
Please find the attachment of the application of better understanding.
I looked at it and i dont understand what you are trying to achieve.
i only assume you change values from column Group to Group Level 1 If it is Temp1, then Group Level 2 if it is Temp2.
You wrote a MASTER table code, but what is a puprose of it? I would use mapping table in DB or XLS to map values instead.
Can you present us with what are you trying to avchieve? From--> To?
That would help me understand. Your current code is just a hardcoded conversion, in my opinion is not a dynamic solution.
Is this really a correct answer?