topic Re: Cross Table into Straight Table in App Development

Cross Table into Straight Table

AlexGol — Thu, 20 Jan 2022 13:51:21 GMT

Hey Guys

Does anyone know how to turn a cross table into a straight table? What syntax to apply?

For example, I have one field with 8 values in a table and I need to cross-table this field in such a way so that those 8 values turn into 8 fields.

Visually like this:

from this

into this

a b c

Many thanks in advance

joaopaulo_delco — Thu, 20 Jan 2022 13:53:43 GMT

I think you can use a Generic Load.

AlexGol — Fri, 21 Jan 2022 08:48:26 GMT

Hi Joaopaulo_delco!

Thank you for your prompt reply. I will give it a go to see if it helps and come back to you soon.

Thanks Alex