Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
11/01/2023 12:56 pm
Pattern is similar to replace. It matches a specific pattern within column values and replaces it with the given value.
Step 1: Once data is imported, click on transformation.
Step 2: Drag and drop the data transformation node onto the main screen. Connect the two nodes.
Step 3: Click on configure to make changes to the data. A data transformation pop-up appears. Select the columns that need change and choose the ‘Pattern’ option from the dropdown.
Step 4: Enter the old pattern value and the new pattern value. Click on the ‘apply’ button. (Refer to the image below).
Step 5: Once the data configuration has been done, click on the run button to run the workflow.
Step 6: Click on the icon in the bottom line. (Refer to the image below).
Step 7: The data is reflected based on the operations selected. (Refer to the images below).
