How do i load a table into LASR on conditional basis?

[aswinrahul_madu]

Hello Everyone,

I was wondering if there is a way to load a table into LASR based on a condition (eg: Load CARS table into LASR where Status='Success').

Any help or suggestions will be much appreciated.

Product Details: SAS Visual Analytics 7.4

Thanks

Aswin

[SASKiwi]

You can load LASR tables using SAS code that contains conditional processing including DATA steps.

[aswinrahul_madu]

Hi SASKiwi,

Thanks for your inputs. Can you help me by citing an example? Right now, i
would like to load table by using a data query.

[itchyeyeballs]

Hi,

How are you loading your LASR tables? Enterprise Guide, DI or Query Builder?

[aswinrahul_madu]

Hello,

I am using data builder to load the tables.

Thanks
Aswin

[JuanS_OCS]

Hello @aswinrahul_madu,

could you already give a look to the Reload-on-start feature? https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1s2hnpd892n7fn1dp18...

Also, interesting to know, Autoload can help you to automatically load data, if you just drop the final dataset in the autoload folder https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0nm6qjzfz4eban1237q...

Besides those options, Your queries can be sent to be scheduled in your OS http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkex...

This means, there will be a scheduled task in your OS scheduler (Windows Task scheduler or cron/at), and you can set triggers in those scheduler. For this last functionality, I would ask support from your system admins.

Hope it helps.

Kind regards,

Juan