Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

insert in multiple table in a loop

I have to write the below logic:

For i <= TotalNoOfRecordinTable Loop

if i.recordType = 'T' then

insert into TTable values ('.............);

elseif i.recordType='C' then

insert into CTable values (.......);

End if;

How I write this logic in Qlik View or QlikSense?

1 Reply
Valued Contributor III

Re: insert in multiple table in a loop

Could you please elaborate on your requirements a little bit?

Do you need to assign specific values to multiple fields in each table?

Or it's just one specific field in each table needs to be updated based on the i.recordType?

In the second case you should be able to do it with setting variables in the for... next loop and assigning these variables to specific fields...



Community Browser