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.
H Ben, I have same challenge but in a different way, Sorry If am reopening this thread, am getting different spreadsheet registers and need to transpose it to make as an upload file to another system.
I tried to create it as a chain app, however the transpose list is not getting refreshed. I need to share this to my different teams so that they can run this by their own.
The images of WF attached, I am getting the input files in diff fomats, so trying to filter blank, add dates, and rename emp number to get this a common key field in transpose. The list is then getting saved as yxmd file in first app and then getting through to transpose. But the list is not getting refreshed.App1App2