topic Re: Macro create straight table with loop in QlikView

Macro create straight table with loop

Michiel_QV_Fan — Mon, 10 Jul 2017 08:37:42 GMT

Hi, I need to create a straight table from a data source with > 100 columns.

These columns are increasing so I want to automate the process of adding the new columns.

Also these columns need an 'Enable condition'.

Is this possible with a macro and how would the loop look like?

The API guide has the example for creating a straight table so that's not the question. How to loop and add the condition?

Thanks!!

gardenierbi — Mon, 10 Jul 2017 09:21:09 GMT

You could build up a table in QV script with all variables for your final table. For example a table with 2 fields : field name & condition.

In your macro you could loop to this table and build your final straight table!

Michiel_QV_Fan — Mon, 10 Jul 2017 09:30:22 GMT

Hi Sander, that sounds like a good plan.

But I'm not sure how to script this.

gardenierbi — Mon, 10 Jul 2017 09:39:09 GMT

This script loop through tables and fields. Replace the DELETE FIELD part for a concatenation of the field to your table.