Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need help on creating columns based on the column's values as below, I have column Tags in Table1 and values are delimeter based (Tag (This need to be column) : Val (This shoud be value).
Table1 :
Tags |
Tag1:Val1;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val2;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val1;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val3;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val1;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val2;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
This need to be transform as :
Tag1 | Tag2 | Tag3 | Tag4 |
Val1 | Val2 | Val1 | Val1 |
Val2 | Val2 | Val1 | Val1 |
Val1 | Val2 | Val1 | Val1 |
Val3 | Val2 | Val1 | Val1 |
Val1 | Val2 | Val1 | Val1 |
Val2 | Val2 | Val1 | Val1 |
i am able to spilt values from Tags column but not able to dynamically renamed the column
Thanks,
Rahul
Solved! Go to Solution.
Hi @Rahul66303,
Please check out the demo here. The solution depends on GUI operations. No code is needed.
Best Regards,
Dale
Hi,
Need to understand if below scenario is possible in Power BI desktop.
I have a table where one of the column (Tags) have delimiter based values as below, what i need to do is dynamically it should add 4 columns Tag1 as column1 and Val1,Val2,Val3 ... as values for Tag1 and similar structure for Tag2, Tag3 and Tag4.
Basically Tags contain ; delimeter for Tag and inside tag : delimeter should be used for column name and values.
Tags |
Tag1:Val1;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val2;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val1;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val3;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val1;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Tag1:Val2;Tag2:Val2;Tag3:Val1;Tag4:Val1 |
Dynamically it should transform as per below, i know we can rename the column but i want it should give me dynamic name based on input in above Tags column .
Tag1 | Tag2 | Tag3 | Tag4 |
Val1 | Val2 | Val1 | Val1 |
Val2 | Val2 | Val1 | Val1 |
Val1 | Val2 | Val1 | Val1 |
Val3 | Val2 | Val1 | Val1 |
Val1 | Val2 | Val1 | Val1 |
Val2 | Val2 | Val1 | Val1 |
Appreciate it if some one can help asap.
Thanks,
Rahul
Hi @Rahul66303,
Please check out the demo here. The solution depends on GUI operations. No code is needed.
Best Regards,
Dale
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |