topic Use an expression in the condition of a do while in App Development

Use an expression in the condition of a do while

Obsyky — Fri, 13 May 2022 08:46:09 GMT

My wish would be to get this type of operation, knowing that VALUEX is in TABLE :

Set a = 0;

Do While a < RangeMax(VALUEX) + 1
Left Join(TABLE)
Load
?????????
Resident TABLE
Where $(a) <= VALUEX;
Let a=a+1;
Loop

I tried making a variable with RangeMax and Peek, but both do not return any value.

Do you have a solution? Thanks

Re: Use an expression in the condition of a do while

vinieme12 — Fri, 13 May 2022 08:41:04 GMT

this script is to filter a table and left join to another table,

what exactly are you trying to do here what is VALUEY and VALUEX ? please clarify

Re: Use an expression in the condition of a do while

Obsyky — Fri, 13 May 2022 08:58:14 GMT

This is a mistake on my part, VALUEY does not exist, it is VALUEX.
VALUEX is simply the number of pipes contained in one of the attributes.
The objective is that I loop as many times as the maximum number of pipes that exist.
Then my method may not be the right one 😕
The maximum number of pipes is 324 and the objective is that I break the values into several attributes to find them in a single value.

What I would like to achieve:
(Knowing that X is the only value I have at the start)

X	VALUEX	SEPARATE1	SEPARATE2	SEPARATE3	SEPARATE4	SEPARATE5
DATA \| DATA1 \| BIG DATA \| BIG \| FARM	4	DATA	DATA1	BIG DATA	BIG	FARM

I could run the loop 324 times, but if there are at most 10 pipes, I will create 314 empty attributes...

Re: Use an expression in the condition of a do while

vinieme12 — Fri, 13 May 2022 09:01:00 GMT

So you have X and ValueX

and you want to split X into multiple columns is that correct?

Re: Use an expression in the condition of a do while

Obsyky — Fri, 13 May 2022 09:03:36 GMT

Completely

Re: Use an expression in the condition of a do while

vinieme12 — Fri, 13 May 2022 09:18:50 GMT

Generic:
Generic Load
Key,Attribute,Value Resident temp;

Set vListOfTables = ;

For vTableNo = 0 to NoOfTables()

Let vTableName = TableName($(vTableNo)) ;

If Subfield(vTableName,'.',1)='Generic' Then

Let vListOfTables = vListOfTables & If(Len(vListOfTables)>0,',') & Chr(39) & vTableName & Chr(39) ;

End If

Next vTableNo;

CombinedGenericTable:

Load distinct Key Resident temp;

For each vTableName in $(vListOfTables)

Left Join (CombinedGenericTable) Load * Resident [$(vTableName)];

Drop Table temp;

Next vTableName