topic Re: Convert a table in App Development

Convert a table

Hunky_Cat — Fri, 21 Apr 2023 08:16:26 GMT

Hi, I need to convert a table from left image to right.

But it's not working because of the '/' I suppose. Could you help find a way to solve this?

hic — Fri, 21 Apr 2023 08:26:49 GMT

Use

Crosstable (class, feature)
Load SKU, "a/q", "b/q", "c/e", "d/r", "e/t", "f/y" From ...

Hunky_Cat — Fri, 21 Apr 2023 08:37:12 GMT

Thank you for your advice, but I need exactly the opposite of what the cross table does

MarcoWedel — Fri, 21 Apr 2023 09:50:06 GMT

Hunky_Cat — Fri, 21 Apr 2023 09:57:09 GMT

Generic will give me 3 separate tables, I need just one combined. And I have much more data so It has to be some sort of cycle

Sabrina_V — Fri, 21 Apr 2023 14:44:54 GMT

MarcoWedel — Fri, 21 Apr 2023 16:59:06 GMT

Those tables can be merged, e.g. like this: