Hi, 1)For below records or dataset, how can I replace "col4"

In continuation to my previous reply....... I am trying to implement a grid which can dynamically create columns based on the data of a single column returned by DB. To explain more preciously, I am getting below table data for Code=xyz. The given dataset contains the complete data I need to show in the grid, however the 'Detailed' column has the set of columns and it's value which I need to split and show in my final grid along with other columns.

Code          col2           col3           Detailed                                        col6
xyz                    asdfsa          ad                    col4~asd|col5~uwu                    adf
xyz                    er                    we                    col4~ut|col5~uu           cwe
xyz                    qqw                    rr                    col4~co|col5~uw                    asdfw

The Detailed column contains the columns separated by '|' and every column name and it's value is separated by '~'. Other than this I also have the details of columns set (name) for given Code=xyz, which is suppose to be different for different Codes (in this case it is "col4", and "col5" for Code=xyz).

Once I retrieve all the columns from 'Detailed' column, appian should show the grid with following details.

Code          col2           col3           col4           col5           col6
xyz                    asdfsa          ad                    asd                    uwu                    adf
xyz                    er                    we                    ut                    uu                    cwe
xyz                    qqw                    rr                    co                    uw                    asdfw

I am trying to implement this with the help of gridTextColumn and gidField, however I find it difficult to prepare the data in the format which gridField expects for this.

Thanks for the help!

In continuation to my previous reply....... I am trying to implement a grid which can dynamically create columns based on the data of a single column returned by DB. To explain more preciously, I am getting below table data for Code=xyz. The given dataset contains the complete data I need to show in the grid, however the 'Detailed' column has the set of columns and it's value which I need to split and show in my final grid along with other columns.

Code          col2           col3           Detailed                                        col6
xyz                    asdfsa          ad                    col4~asd|col5~uwu                    adf
xyz                    er                    we                    col4~ut|col5~uu           cwe
xyz                    qqw                    rr                    col4~co|col5~uw                    asdfw

The Detailed column contains the columns separated by '|' and every column name and it's value is separated by '~'. Other than this I also have the details of columns set (name) for given Code=xyz, which is suppose to be different for different Codes (in this case it is "col4", and "col5" for Code=xyz).

Once I retrieve all the columns from 'Detailed' column, appian should show the grid with following details.

Code          col2           col3           col4           col5           col6
xyz                    asdfsa          ad                    asd                    uwu                    adf
xyz                    er                    we                    ut                    uu                    cwe
xyz                    qqw                    rr                    co                    uw                    asdfw

I am trying to implement this with the help of gridTextColumn and gidField, however I find it difficult to prepare the data in the format which gridField expects for this.

Thanks for the help!