Forum Discussion
Convert every 6 rows into columns
Hi guys! Can anyone help me? I have around 7.000 lines with data - a XML file. Every 4 rows the "block" starts again. It's always "group, name, number, data" Something like this: Column1 -...
Brazil is great, I'm helping you from Portugal! 😀
Sorry if I skipped some detailed steps...
You need to go here:
After that, write the following code (for each column you gonna need), adapting your if-statement to each column.
E.g.:
Column Name = if [Column 2] = "Name" then [Column 1] else null Column Id = if [Column 2] = "Id" then [Column 1] else null ...Um abraço! 😀
Hi Edu!
Greetings from Brazil 😉
I couldn't add the first line (if [Column 2] = ##Column_to_be_created then [Column 1] else null)
..I'm kind of newbie at PBI.
I've tried to insert your string at custom column but showed me "expected literal token" 😕
Brazil is great, I'm helping you from Portugal! 😀
Sorry if I skipped some detailed steps...
You need to go here:
After that, write the following code (for each column you gonna need), adapting your if-statement to each column.
E.g.:
Column Name = if [Column 2] = "Name" then [Column 1] else null
Column Id = if [Column 2] = "Id" then [Column 1] else null
...
Um abraço! 😀