Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dynamically referencing a table column using mapping table?

I'm trying to produce a query that allows a user to map attributes from a source file to the target fields in the "output" table and have the table populated using the content of the file.   I have...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

Do you want to change the column name in the function? Can you provide more information, I am confused about it, do you mean that you want to fiter the value based on the dynamic column?

 

Best Regards!

Yolo Zhu

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Thanks for your response! Basically I am trying to convert a source table into a template so would be aiming to change the header names. Usually I would just map this myself, but I am trying to create a simple means for a user to map the source fields (from the input file) to the relevant attributes in the template ("Target Attribute Name" in the image above) so that all the records from the source file, populate the table in the 'target' using the Target Attribute Names - kind of a very basic ETL that I am trying to achieve!