Good afternoon. I am in need of a transformer that can promote a certain row to create attributes Dynamically. It would be like a power query promote first row to header.
I am reading a text file but text_line_data is coming in as the attribute instead of the data from the first row. This could be useful when reading csv files and specifying a particular row that has the attribute names.