Ask Your Question
4

What is the process for converting a common data type into an array format using Cloud Data Fusion Wrangler?

asked 2021-04-10 11:00:00 +0000

huitzilopochtli gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2021-04-15 14:00:00 +0000

qstack gravatar image

The process for converting a common data type into an array format using Cloud Data Fusion Wrangler includes the following steps:

  1. Open the Cloud Data Fusion Wrangler interface and select the dataset you want to convert into an array format.

  2. Select the column containing the data you want to convert to an array format.

  3. To create an array of the column data, click on the "Split" option from the transform menu.

  4. In the "Split" dialogue box, enter the delimiter character separating the values. If the delimiter is not present, then select the "By Length" option and enter the length of each value.

  5. Choose the option to create a new column, and give the new column a name.

  6. Click on "Add Transformation" to add the new column with array data.

  7. Save the transformation and run the Data Pipeline.

  8. Check the output result to confirm that the array data was created successfully.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2021-04-10 11:00:00 +0000

Seen: 14 times

Last updated: Apr 15 '21