Need Help with below Transformation in BigQuery,
Here CMPTTR NAME will increase dynamically from 2 to n:
CodePudding user response：
Consider below approach
if applied to sample data in your question - output is
Need Help with below Transformation in BigQuery,
Here CMPTTR NAME will increase dynamically from 2 to n:
CodePudding user response：
Consider below approach
if applied to sample data in your question - output is