Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 -...
Need Help
  • edugoncalves's avatar
    edugoncalves
    5 years ago

    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! 😀

     

edugoncalves's avatar
edugoncalves
Icon for Resolver I rankResolver I
5 years ago

Hi Anonymous ,
I think I've found a receipt for this!
Used the following sample data:

 

 

Then created 4 custom columns with the following code:
if [Column 2] = ##Column_to_be_created then [Column 1] else null

 

 

After that, you need to fill-down the first custom column created and fill-up the last one and the penultimate

 

 

 

To finish, filter the third column to eliminate null values

 

 

Note: This solution may not be feasible for other scenarios, and it is better to confirm that you do not "lose" data through the process...

 

Any questions, don't hesitate!

 

Best Regards,

Eduardo

 

[Edited because sample data was wrong.]