This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In the background essentially I record ID the data stream and then use a dynamic select tool to only keep columns that are either the record ID or match the regex statement provided by the user, and then pivot any columns that match around the ID.
As a separate stream I also select the record ID and any fields that do not match the criteria and then join these to the first stream after the transpose.