Question

Which transform function would you use to operate the filename values into two separate columns, one for the filename and the other for the file extension? e. G. , xml

Answer 1

The transform function that a person can use to operate the filename values is Split Column - Split at Right-most delimiter

What is Split a column by delimiter?

A person can split or divide a column that has a text data type into multiple columns via the use of a common delimiter character.

An example is: A Name column that has some values written that is <LastName>, <FirstName> This is one that can be divided into two columns via the use of the comma (,) character.

Therefore, The transform function that a person can use to operate the filename values is Split Column - Split at Right-most delimiter which is option d.

See options below

A. Extract - Text before delimiter

B. Split Column - Split at Each occurrence of the delimiter

C. Extract - Text after delimiter

D. Split Column - Split at Right-most delimiter

Learn more about transform function from

brainly.com/question/1548871

#SPJ12