Faster way to remove orphan fields from data model

[Aditya_Chitale]

Hello Everyone,

I am working with a large Qlik sense data model where we have huge number of orphan fields which are not being used in frontend charts as well as not used anywhere for linking of tables or calculations in the load script.

I want to remove those fields from the data model to improve performance. Since the number of such fields is very high, is there any faster way or any shortcut method to remove those fields ? I can't keep on removing the fields manually one by one as it is taking a lot of time.

Any help on this is highly appreciated.

Regards,

Aditya

[Or]

Since you're not interested in just dropping the fields at the end of the script, I would say there's no good approach other than doing it manually. The fact that a field is orphaned at the end of the script doesn't mean it isn't doing something during the load process, meaning you'll have to evaluate each one by hand and confirm it can be safely removed. Otherwise, you could end up removing fields temporarily used for conditions, joins, etc. during the script load process. 

[rwunderlich]

Using the QSDA Pro script generator tool you can either generate a DROP FIELDS statement for unused fields or LOAD statements with commented fieldnames if you want to avoid loading the unused fields altogether.