Drop Field

[gauthamchilled]

Hi

I ran the Doc analyzer as per the idea to get the list of fields which are unused.

I added the drop fields statement in my dashboard at the end. But after reloading the dashboard, once the script execution is over

the dashboard hangs.

But if i remove the drop statement of unused fields, the dashboard not hang.

how can i fix this?

file size is 150MB, RAM is 6GB. this happens in empty sheet with no objects.

[Anonymous]

may be something wrong in syntax?

You can drop fields like this?

Load

//A,      By Commenting

//B,

C

From Table;

or

drop fields A,B;

or

drop field A;

Hope this will help!!

[Chanty4u]

based on ur num of chrts

and num set expressions in frnt end...

if is there any macros.

highly coulr coding..

may hangs ur app.

[Chanty4u]

did u restrt ur machine and reload again?

May be 

[gauthamchilled]

rwunderlich‌

Do you have any idea?

[Anonymous]

Could you share your script?

[jagan]

Hi Gautham,

I think the dropped field is using somewhere in the charts that is why you are getting this issue.  Check carefully.

Regards,

Jagan.

[Siva_Sankar · Accepted solution]

Gautham,

Check the drop field that you copied from doc analyzer have some key columns(escpecially composite key columns).

Try commenting those columns and run the app. Check if you see the issue is gone.

You can narrow down the issue in this way.

If they keys causes the issue, then try autonumber function on creating those composite keys and then use it in drop field statement.

[Anonymous]

may be connections problem or expressions wrong

[gauthamchilled]

Thanks Shankarece.. The composite key columns were the issue. Resolved now.

Gautham