This content has been marked as final. Show 2 replies
- Pivot columns – Pivot fields to transform data in a crosstab format into a columnar format. This is only available for non-legacy connection types. For more information, see Pivot Data from Columns to Rows.
- Split columns – Split a string field into multiple fields. This is only available for non-legacy connection types. For more information, see Split a Field into Multiple Fields.
No use of custom sql then go with non legacy.
Thanks Sanker for the quick respons !