Skip to main content
Solved

Table flattening - Order/OrderLines

  • September 11, 2025
  • 3 replies
  • 50 views

Forum|alt.badge.img

Hi,

I got this structure(see below) from my rest api and I need to add order_id into each line of order_line. 

How can I flatten out order_lines with the order_id? I have tryed different  ways, but when I have two order lines only one get the right order_id value….

 

Order/Orderlines

best regards,
Bjørn A.

Best answer by Thomas Lind

Hi ​@bjorn 

The order_lines part needs to be the root. Then if you add the fields from the orders level there will be a order_id with multiple order_id_lines.

Are you using TDI or v20?

 

3 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • Answer
  • September 11, 2025

Hi ​@bjorn 

The order_lines part needs to be the root. Then if you add the fields from the orders level there will be a order_id with multiple order_id_lines.

Are you using TDI or v20?

 


Forum|alt.badge.img
  • Author
  • Contributor
  • September 11, 2025

Hi Thomas,

I am using TDI,

Thanks, will try out your suggestion…

 

/Bjørn A.


Forum|alt.badge.img
  • Author
  • Contributor
  • September 12, 2025

Hi Thomas,

Thanks, I used “Data structure” = Generic to get it to work :-)
 


best regards,

Bjørn A: