Forum Discussion

gtamir1's avatar
gtamir1
Helper I
5 years ago
Solved

Separate fields

Hi, I get data from a database as shown in the picture. Line 1 and 9 are the main transaction, and lines 3-8 are what I call Sub Transaction. they belong to the main transaction, describing the elements comprises the main part. 
How can I separate all fields to columns and values?
In short, I want all lines to be one line of fiels names and values.

Need Help
  • gtamir1's avatar
    gtamir1
    5 years ago

    Thanks for your answer. Meanwhile the customer says he will send the data in another format so I don't want to buther you whith that.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Please provide sample data in usable format (not as a picture) and show the expected outcome.

  • gtamir1's avatar
    gtamir1
    Helper I
    5 years ago

    Thanks for your answer. Meanwhile the customer says he will send the data in another format so I don't want to buther you whith that.