Consider a column having values in the form of 'Production-Technician-Support-AW-1000045'. A 'Split Column by delimiter' transformation is used on this column with 'left-most delimiter' radio button selected for 'Split-at' option in Query Editor. How many split columns will be created after this transformation is applied on the column?

1.0

2.0

5.0

Depends on the delimiter

Verified Answer
Correct Option - b

To get all Infosys Certified Microsoft Power BI Advanced Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram