topic insert in multiple table in a loop in App Development

insert in multiple table in a loop

madnanansari — Sat, 18 Mar 2017 12:40:25 GMT

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?

vlad_komarov — Wed, 22 Mar 2017 21:26:00 GMT

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