Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
madnanansari
Creator
Creator

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
vlad_komarov
Partner - Specialist III
Partner - Specialist III

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...

Regards,

Vlad