This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a data coming in the following format post harmonisation
I wish to fill the values in the column in an empty data table by matching the headers from the data I have from harmonisation. I tried to add empty columns but the report will contain column names changing everyday, for example, the data for tuesday will only contain qty_monday and for wednesday it will contain qty_tuesday. I need to match the header names from the table and fill the rows corresponding to the column name in the empty data table I have required for the final format.