Currently split option in dataset have limited options.
We should have more options like
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.
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
D
p3,p4
E
p1,p3
F
After split into rows.
p1
p2
p4
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.
C3
C1,C2,C3,C4
C1,C3,C4
C3,C4
C1,C3
C1,C2,C3
After split it looks like below.
C1
C2
C4
Any updates?
