Split Columns in Dataset should have more options like Power BI.

Rajakumar Burra

Currently split option in dataset have limited options.

We should have more options like

• Converting to Rows.
• Automatically add number of columns based on max possible split.

Rajakumar Burra

Yes . Columns will duplicate.

Use case, we have different teams uses different software & instances. When we download our usage data , products list in one column with comma separated like below. We want to get the details of cost allocation by Dept ,Product, common users and unique users

Please see attached.

test1.xlsx

Rajakumar Burra

Yes. Rest of the columns should be duplicated.

We have enterprise licenses for software.

When we take dump, output will be like below with more attributes. We want to find common find out unique users, common users to different products, dept allocation costs, product allocation costs etc. If Columns are converted to rows, calculations become easy.

Example source data.

Name	Product 1	Product 2
A	p1,p2,p3	p3
B	p1,p3,p4	p1,p2,p3,p4
C	p3	p1,p3,p4
D	p1,p2,p3,p4	p3,p4
E	p3,p4	p1,p3
F	p1,p3	p1,p2,p3

After split into rows.

Name	Product 1	Product 2
A	p1	p3
A	p2	p3
A	p3	p3
B	p1	p1
B	p1	p2
B	p1	p3
B	p1	p4
B	p3	p1
B	p3	p2
B	p3	p3
B	p3	p4
B	p4	p1
B	p4	p2
B	p4	p3
B	p4	p4
C	p3	p1
C	p3	p3
C	p3	p4
D	p1	p3
D	p1	p4
D	p2	p3
D	p2	p4
D	p3	p3
D	p3	p4
D	p4	p3
D	p4	p4
E	p3	p1
E	p3	p3
E	p4	p1
E	p4	p3
F	p1	p1
F	p1	p2
F	p1	p3
F	p3	p1
F	p3	p2
F	p3	p3

Rajakumar Burra

Yes . Columns will duplicate.

Use case, we have different teams uses different software & instances. When we download our usage data , products list in one column with comma separated like below . We want to get the details of cost allocation by Dept ,Product, common users and unique users etc.

Name	Product 1	Product 2
A	p1,p2,p3	C3
B	p1,p3,p4	C1,C2,C3,C4
C	p3	C1,C3,C4
D	p1,p2,p3,p4	C3,C4
E	p3,p4	C1,C3
F	p1,p3	C1,C2,C3

After split it looks like below.

Name	Product 1	Product 2
A	p1	C3
A	p2	C3
A	p3	C3
B	p1	C1
B	p1	C2
B	p1	C3
B	p1	C4
B	p3	C1
B	p3	C2
B	p3	C3
B	p3	C4
B	p4	C1
B	p4	C2
B	p4	C3
B	p4	C4
C	p3	C1
C	p3	C3
C	p3	C4
D	p1	C3
D	p1	C4
D	p2	C3
D	p2	C4
D	p3	C3
D	p3	C4
D	p4	C3
D	p4	C4
E	p3	C1
E	p3	C3
E	p4	C1
E	p4	C3
F	p1	C1
F	p1	C2
F	p1	C3
F	p3	C1
F	p3	C2
F	p3	C3