Ankita P.

Commented on How to Exclude Records with Empty Business Unit Va...·Posted inCommunity Questions

I tried the same pipeline, with modified source query :

SELECT BUSINESS_UNIT AS DEGREE_UNIT,BU_DESCR AS DESCR FROM BUSINESS_UNIT_DIM  WHERE TRIM(BUSINESS_UNIT) <> ''
  AND BU_DESCR <> 'Unassigned' GROUP BY BUSINESS_UNIT, BU_DESCR

It still failed at target.

Posted in Community Questions·

Ankita P.

How to Exclude Records with Empty Business Unit Values in SnapLogic Source Query

Hello everyone, I am using a source query as below SELECT BUSINESS_UNIT AS DEGREE_UNIT,BU_DESCR AS DESCR FROM BUSINESS_UNIT_DIM WHERE or BUSINESS_UNIT != '' or BUSINESS_UNIT != ' ' GROUP BY BUSINESS_UNIT, BU_DESCR In the BUSINESS_UNIT_DIM table there is a row with BU_DESCR = 'Unassigned'and BUSINESS_UNIT = ' ' We want to discard this record in the target. Somehow Snaplogic is still picking this particular record up using this source query and failing at the target. How do I handle this situation. Any suggestions are welcome!

2Comments

Posted in Community Questions·

Ankita P.

How to Resolve Unable to Contact CC to Start Runtime Error When Running Pipelines

I am getting an error saying the below while trying to run pipelines. Any suggestions?

Unable to prepare pipeline on node: uadvdev-slgc-01 (6a61d8b61b2a535bd6fa81e3)
Reason:Unable to contact CC to start runtime.
Resolution:Check network connectivity with the Snaplex node.

1Comment

About

Company
Title