topic Re: Updating Project Name in Script in Search the Community

Updating Project Name in Script

manassrivastava — Tue, 11 Jan 2022 13:55:18 GMT

Hi Team,

Is there a way to update only a certain project name in the Data Load Script (highlighted in yellow)

When I ran it, i got an error

The report name is ORTELE Tele-Medicine Platform [SOW#3]

How to add this filter in the script

Re: Updating Project Name in Script

rwunderlich — Tue, 11 Jan 2022 15:22:54 GMT

Do you mean you want to change the name of the field 'Nrich__Project_Name__c" to "ORTELE Tele-Medicine Platform [SOW#3]"? If so, use the "AS" clause. See the earlier lines in your script for an example.

-Rob

Re: Updating Project Name in Script

manassrivastava — Tue, 11 Jan 2022 15:44:07 GMT

Hi Rob,

No I meant to only include the Project ORTELE Tele-Medicine Platform [SOW#3] in the dashboard

Currently it is pulling data for 50 projects but I just want this dashboard to all data / charts for the project ORTELE Tele-Medicine Platform [SOW#3]

I tried to lock the filter pane but that does not work permanently

So i was thinking if somehow I can make some edit in the script so that It only picks data for this project and exludes data for all other projects

Re: Updating Project Name in Script

rwunderlich — Tue, 11 Jan 2022 17:30:43 GMT

In your Load statement, add a where clause:

Where [Nrich__Project_Name__c] = 'ORTELE Tele-Medicine Platform [SOW#3]'

If you are loading from SQL Select, it can be more efficient to add the Where in the SQL instead.

Check out the doc to understand where to place "where" in Load statement. https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Load.htm

If you have more questions about this, please post your entire Load statement.

-Rob