I suppose with the new Data Prep, you can do almost the same as in custom SQL ?
2 answers
Hi Luc,
- 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
sankar