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
To get all Infosys Certified Microsoft Power BI Advanced Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee