Extracting and analyzing part of data

[#1]

Greetings

I have the following Data

AUTOMACHINE:

LOAD USER_ID,

PARAM1,

PARAM2,

PARAM3,

PARAM4,

DATAS1,

DATAS2,

DATAS3,

DATAS4

DATAS5,

DATAS6,

...

..

..

DATAS91

FROM

(ooxml, embedded labels);

First I am loading the table and analyzing for some specific needs. This first part works.

Second part I want to analyze part of tables So I need to extract the data

The condition is If PARAM1 > (PARAM2+ PARAM3+ PARAM4) Then  I need to Get DATA      DATAS1...  to DATAS91

How do I extract all DATAS1  to DATAS91 ?

Thanks

[tresesco]

try:

AUTOMACHINE:

LOAD USER_ID,

DATAS1,

DATAS2,

DATAS3,

DATAS4

DATAS5,

DATAS6,

...

..

..

DATAS91

FROM

(ooxml, embedded labels) WHERE PARAM1 > (PARAM2+ PARAM3+ PARAM4);

[#3]

Thank you Tresesco for your quick reply.

So I need to load twice my table as per below?

AUTOMACHINE:

LOAD USER_ID,

PARAM1,

PARAM2,

PARAM3,

PARAM4,

DATAS1,

DATAS2,

DATAS3,

DATAS4

DATAS5,

DATAS6,

...

..

..

DATAS91

FROM

(ooxml, embedded labels);

AUTOMACHINE2:

LOAD USER_ID,

DATAS1,

DATAS2,

DATAS3,

DATAS4

DATAS5,

DATAS6,

...

..

..

DATAS91

FROM

(ooxml, embedded labels) WHERE PARAM1 > (PARAM2+ PARAM3+ PARAM4);