Hi

The data are grouped according to the value of the config table.

The fields in the config table are ID, Type. The data in the config table are

1 --...

Hi tinku

Thanks for the reply. Pivot clause cannot be used in this scenario, because, the column name is not static, it is taken from the first table "Config" 🙁